using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VMGSTAMM
    {
        public DataRow Convert2MGSTAMM(DataRow dwInput, string ITXDBVERSION, bool IsConvert = false)
        {
            DataSet SResult = new DataSet();
            SResult = QueryMGSTAMM(dwInput, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].NewRow();
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                    #region=========
         dwReturn["MGMANDANT"] = " ".PadRight(2 ); 
         dwReturn["MGMAT"] = " ".PadRight(14 ); 
         dwReturn["MGVAR"] = " ".PadRight(3 ); 
         dwReturn["MGSTAKZ"] = " ".PadRight(1 ); 
         dwReturn["MGLIEFNR"] = " ".PadRight(8 ); 
         dwReturn["MGADRSL"] = " ".PadRight(8 ); 
         dwReturn["MGNOTASKFT"] = " ".PadRight(50 ); 
         dwReturn["MGNOTTEL"] = " ".PadRight(15 ); 
         dwReturn["MGSDBLDAT"] = " ".PadRight(0 ); 
         dwReturn["MGSYNONYM1"] = " ".PadRight(25 ); 
         dwReturn["MGSYNONYM2"] = " ".PadRight(25 ); 
         dwReturn["MGSYNONYM3"] = " ".PadRight(25 ); 
         dwReturn["MGSYNONYM4"] = " ".PadRight(25 ); 
         dwReturn["MGSYNONYM5"] = " ".PadRight(25 ); 
         dwReturn["MGCHEMCHAR1"] = " ".PadRight(50 ); 
         dwReturn["MGCHEMCHAR2"] = " ".PadRight(50 ); 
         dwReturn["MGCHEMCHAR3"] = " ".PadRight(50 ); 
         dwReturn["MGCASNR"] = " ".PadRight(11 ); 
         dwReturn["MGEGNR"] = " ".PadRight(12 ); 
         dwReturn["MGEINECS"] = " ".PadRight(7 ); 
         dwReturn["MGZUBEREIT1"] = " ".PadRight(50 ); 
         dwReturn["MGZUBEREIT2"] = " ".PadRight(50 ); 
         dwReturn["MGDCASNR1"] = " ".PadRight(11 ); 
         dwReturn["MGPROZVON1"] = " ".PadRight(0 ); 
         dwReturn["MGPROZBIS1"] = " ".PadRight(0 ); 
         dwReturn["MGKENNB11"] = " ".PadRight(2 ); 
         dwReturn["MGKENNB21"] = " ".PadRight(2 ); 
         dwReturn["MGKENNB31"] = " ".PadRight(2 ); 
         dwReturn["MGRSTZ1"] = " ".PadRight(11 ); 
         dwReturn["MGR11"] = " ".PadRight(2 ); 
         dwReturn["MGR21"] = " ".PadRight(2 ); 
         dwReturn["MGR31"] = " ".PadRight(2 ); 
         dwReturn["MGR41"] = " ".PadRight(2 ); 
         dwReturn["MGDCASNR2"] = " ".PadRight(11 ); 
         dwReturn["MGPROZVON2"] = " ".PadRight(0 ); 
         dwReturn["MGPROZBIS2"] = " ".PadRight(0 ); 
         dwReturn["MGKENNB12"] = " ".PadRight(2 ); 
         dwReturn["MGKENNB22"] = " ".PadRight(2 ); 
         dwReturn["MGKENNB32"] = " ".PadRight(2 ); 
         dwReturn["MGRSTZ2"] = " ".PadRight(11 ); 
         dwReturn["MGR12"] = " ".PadRight(2 ); 
         dwReturn["MGR22"] = " ".PadRight(2 ); 
         dwReturn["MGR32"] = " ".PadRight(2 ); 
         dwReturn["MGR42"] = " ".PadRight(2 ); 
         dwReturn["MGDCASNR3"] = " ".PadRight(11 ); 
         dwReturn["MGPROZVON3"] = " ".PadRight(0 ); 
         dwReturn["MGPROZBIS3"] = " ".PadRight(0 ); 
         dwReturn["MGKENNB13"] = " ".PadRight(2 ); 
         dwReturn["MGKENNB23"] = " ".PadRight(2 ); 
         dwReturn["MGKENNB33"] = " ".PadRight(2 ); 
         dwReturn["MGRSTZ3"] = " ".PadRight(11 ); 
         dwReturn["MGR13"] = " ".PadRight(2 ); 
         dwReturn["MGR23"] = " ".PadRight(2 ); 
         dwReturn["MGR33"] = " ".PadRight(2 ); 
         dwReturn["MGR43"] = " ".PadRight(2 ); 
         dwReturn["MGDCASNR4"] = " ".PadRight(11 ); 
         dwReturn["MGPROZVON4"] = " ".PadRight(0 ); 
         dwReturn["MGPROZBIS4"] = " ".PadRight(0 ); 
         dwReturn["MGKENNB14"] = " ".PadRight(2 ); 
         dwReturn["MGKENNB24"] = " ".PadRight(2 ); 
         dwReturn["MGKENNB34"] = " ".PadRight(2 ); 
         dwReturn["MGRSTZ4"] = " ".PadRight(11 ); 
         dwReturn["MGR14"] = " ".PadRight(2 ); 
         dwReturn["MGR24"] = " ".PadRight(2 ); 
         dwReturn["MGR34"] = " ".PadRight(2 ); 
         dwReturn["MGR44"] = " ".PadRight(2 ); 
         dwReturn["MGDCASNR5"] = " ".PadRight(11 ); 
         dwReturn["MGPROZVON5"] = " ".PadRight(0 ); 
         dwReturn["MGPROZBIS5"] = " ".PadRight(0 ); 
         dwReturn["MGKENNB15"] = " ".PadRight(2 ); 
         dwReturn["MGKENNB25"] = " ".PadRight(2 ); 
         dwReturn["MGKENNB35"] = " ".PadRight(2 ); 
         dwReturn["MGRSTZ5"] = " ".PadRight(11 ); 
         dwReturn["MGR15"] = " ".PadRight(2 ); 
         dwReturn["MGR25"] = " ".PadRight(2 ); 
         dwReturn["MGR35"] = " ".PadRight(2 ); 
         dwReturn["MGR45"] = " ".PadRight(2 ); 
         dwReturn["MGDCASNR6"] = " ".PadRight(11 ); 
         dwReturn["MGPROZVON6"] = " ".PadRight(0 ); 
         dwReturn["MGPROZBIS6"] = " ".PadRight(0 ); 
         dwReturn["MGKENNB16"] = " ".PadRight(2 ); 
         dwReturn["MGKENNB26"] = " ".PadRight(2 ); 
         dwReturn["MGKENNB36"] = " ".PadRight(2 ); 
         dwReturn["MGRSTZ6"] = " ".PadRight(11 ); 
         dwReturn["MGR16"] = " ".PadRight(2 ); 
         dwReturn["MGR26"] = " ".PadRight(2 ); 
         dwReturn["MGR36"] = " ".PadRight(2 ); 
         dwReturn["MGR46"] = " ".PadRight(2 ); 
         dwReturn["MGDCASNR7"] = " ".PadRight(11 ); 
         dwReturn["MGPROZVON7"] = " ".PadRight(0 ); 
         dwReturn["MGPROZBIS7"] = " ".PadRight(0 ); 
         dwReturn["MGKENNB17"] = " ".PadRight(2 ); 
         dwReturn["MGKENNB27"] = " ".PadRight(2 ); 
         dwReturn["MGKENNB37"] = " ".PadRight(2 ); 
         dwReturn["MGRSTZ7"] = " ".PadRight(11 ); 
         dwReturn["MGR17"] = " ".PadRight(2 ); 
         dwReturn["MGR27"] = " ".PadRight(2 ); 
         dwReturn["MGR37"] = " ".PadRight(2 ); 
         dwReturn["MGR47"] = " ".PadRight(2 ); 
         dwReturn["MGGEFAHR1"] = " ".PadRight(50 ); 
         dwReturn["MGGEFAHR2"] = " ".PadRight(50 ); 
         dwReturn["MGGEFAHR3"] = " ".PadRight(50 ); 
         dwReturn["MGGEFAHR4"] = " ".PadRight(50 ); 
         dwReturn["MGGEFAHR5"] = " ".PadRight(50 ); 
         dwReturn["MGGEFAHR6"] = " ".PadRight(50 ); 
         dwReturn["MGGEFAHR7"] = " ".PadRight(50 ); 
         dwReturn["MGGEFAHR8"] = " ".PadRight(50 ); 
         dwReturn["MGALLGEM1"] = " ".PadRight(50 ); 
         dwReturn["MGALLGEM2"] = " ".PadRight(50 ); 
         dwReturn["MGALLGEM3"] = " ".PadRight(50 ); 
         dwReturn["MGSYMALLG"] = " ".PadRight(2 ); 
         dwReturn["MGATMEN1"] = " ".PadRight(50 ); 
         dwReturn["MGATMEN2"] = " ".PadRight(50 ); 
         dwReturn["MGATMEN3"] = " ".PadRight(50 ); 
         dwReturn["MGHAUT1"] = " ".PadRight(50 ); 
         dwReturn["MGHAUT2"] = " ".PadRight(50 ); 
         dwReturn["MGHAUT3"] = " ".PadRight(50 ); 
         dwReturn["MGAUGEN1"] = " ".PadRight(50 ); 
         dwReturn["MGAUGEN2"] = " ".PadRight(50 ); 
         dwReturn["MGAUGEN3"] = " ".PadRight(50 ); 
         dwReturn["MGVSCHLUCK1"] = " ".PadRight(50 ); 
         dwReturn["MGVSCHLUCK2"] = " ".PadRight(50 ); 
         dwReturn["MGVSCHLUCK3"] = " ".PadRight(50 ); 
         dwReturn["MGARZT"] = " ".PadRight(50 ); 
         dwReturn["MGGLOESCH1"] = " ".PadRight(50 ); 
         dwReturn["MGGLOESCH2"] = " ".PadRight(50 ); 
         dwReturn["MGULOESCH1"] = " ".PadRight(50 ); 
         dwReturn["MGULOESCH2"] = " ".PadRight(50 ); 
         dwReturn["MGBESGEF1"] = " ".PadRight(50 ); 
         dwReturn["MGBESGEF2"] = " ".PadRight(50 ); 
         dwReturn["MGSCHUTZ1"] = " ".PadRight(50 ); 
         dwReturn["MGSCHUTZ2"] = " ".PadRight(50 ); 
         dwReturn["MGBRAND1"] = " ".PadRight(50 ); 
         dwReturn["MGBRAND2"] = " ".PadRight(50 ); 
         dwReturn["MGBRAND3"] = " ".PadRight(50 ); 
         dwReturn["MGPSCHUTZ1"] = " ".PadRight(50 ); 
         dwReturn["MGPSCHUTZ2"] = " ".PadRight(50 ); 
         dwReturn["MGUSCHUTZ1"] = " ".PadRight(50 ); 
         dwReturn["MGUSCHUTZ2"] = " ".PadRight(50 ); 
         dwReturn["MGENTSORG1"] = " ".PadRight(50 ); 
         dwReturn["MGENTSORG2"] = " ".PadRight(50 ); 
         dwReturn["MGENTSORG3"] = " ".PadRight(50 ); 
         dwReturn["MGFREIHINW1"] = " ".PadRight(50 ); 
         dwReturn["MGFREIHINW2"] = " ".PadRight(50 ); 
         dwReturn["MGFREIHINW3"] = " ".PadRight(50 ); 
         dwReturn["MGUMGANG1"] = " ".PadRight(50 ); 
         dwReturn["MGUMGANG2"] = " ".PadRight(50 ); 
         dwReturn["MGEXPLSCHZ1"] = " ".PadRight(50 ); 
         dwReturn["MGEXPLSCHZ2"] = " ".PadRight(50 ); 
         dwReturn["MGSYMEXPL"] = " ".PadRight(2 ); 
         dwReturn["MGLAGANF1"] = " ".PadRight(50 ); 
         dwReturn["MGLAGANF2"] = " ".PadRight(50 ); 
         dwReturn["MGLAGHINW1"] = " ".PadRight(50 ); 
         dwReturn["MGLAGHINW2"] = " ".PadRight(50 ); 
         dwReturn["MGLAGBED"] = " ".PadRight(50 ); 
         dwReturn["MGLAGKL"] = " ".PadRight(2 ); 
         dwReturn["MGTEMPVON"] = " ".PadRight(0 ); 
         dwReturn["MGTEMPBIS"] = " ".PadRight(0 ); 
         dwReturn["MGGESTANL1"] = " ".PadRight(50 ); 
         dwReturn["MGGESTANL2"] = " ".PadRight(50 ); 
         dwReturn["MGGESTANL3"] = " ".PadRight(50 ); 
         dwReturn["MGECASNR1"] = " ".PadRight(11 ); 
         dwReturn["MGART11"] = " ".PadRight(3 ); 
         dwReturn["MGWERT11"] = " ".PadRight(0 ); 
         dwReturn["MGME11"] = " ".PadRight(3 ); 
         dwReturn["MGART21"] = " ".PadRight(3 ); 
         dwReturn["MGWERT21"] = " ".PadRight(0 ); 
         dwReturn["MGME21"] = " ".PadRight(3 ); 
         dwReturn["MGART31"] = " ".PadRight(3 ); 
         dwReturn["MGWERT31"] = " ".PadRight(8 ); 
         dwReturn["MGME31"] = " ".PadRight(3 ); 
         dwReturn["MGECASNR2"] = " ".PadRight(11 ); 
         dwReturn["MGART12"] = " ".PadRight(3 ); 
         dwReturn["MGWERT12"] = " ".PadRight(0 ); 
         dwReturn["MGME12"] = " ".PadRight(3 ); 
         dwReturn["MGART22"] = " ".PadRight(3 ); 
         dwReturn["MGWERT22"] = " ".PadRight(0 ); 
         dwReturn["MGME22"] = " ".PadRight(3 ); 
         dwReturn["MGART32"] = " ".PadRight(3 ); 
         dwReturn["MGWERT32"] = " ".PadRight(8 ); 
         dwReturn["MGME32"] = " ".PadRight(3 ); 
         dwReturn["MGECASNR3"] = " ".PadRight(11 ); 
         dwReturn["MGART13"] = " ".PadRight(3 ); 
         dwReturn["MGWERT13"] = " ".PadRight(0 ); 
         dwReturn["MGME13"] = " ".PadRight(3 ); 
         dwReturn["MGART23"] = " ".PadRight(3 ); 
         dwReturn["MGWERT23"] = " ".PadRight(0 ); 
         dwReturn["MGME23"] = " ".PadRight(3 ); 
         dwReturn["MGART33"] = " ".PadRight(3 ); 
         dwReturn["MGWERT33"] = " ".PadRight(8 ); 
         dwReturn["MGME33"] = " ".PadRight(3 ); 
         dwReturn["MGECASNR4"] = " ".PadRight(11 ); 
         dwReturn["MGART14"] = " ".PadRight(3 ); 
         dwReturn["MGWERT14"] = " ".PadRight(0 ); 
         dwReturn["MGME14"] = " ".PadRight(3 ); 
         dwReturn["MGART24"] = " ".PadRight(3 ); 
         dwReturn["MGWERT24"] = " ".PadRight(0 ); 
         dwReturn["MGME24"] = " ".PadRight(3 ); 
         dwReturn["MGART34"] = " ".PadRight(3 ); 
         dwReturn["MGWERT34"] = " ".PadRight(8 ); 
         dwReturn["MGME34"] = " ".PadRight(3 ); 
         dwReturn["MGECASNR5"] = " ".PadRight(11 ); 
         dwReturn["MGART15"] = " ".PadRight(3 ); 
         dwReturn["MGWERT15"] = " ".PadRight(0 ); 
         dwReturn["MGME15"] = " ".PadRight(3 ); 
         dwReturn["MGART25"] = " ".PadRight(3 ); 
         dwReturn["MGWERT25"] = " ".PadRight(0 ); 
         dwReturn["MGME25"] = " ".PadRight(3 ); 
         dwReturn["MGART35"] = " ".PadRight(3 ); 
         dwReturn["MGWERT35"] = " ".PadRight(8 ); 
         dwReturn["MGME35"] = " ".PadRight(3 ); 
         dwReturn["MGECASNR6"] = " ".PadRight(11 ); 
         dwReturn["MGART16"] = " ".PadRight(3 ); 
         dwReturn["MGWERT16"] = " ".PadRight(0 ); 
         dwReturn["MGME16"] = " ".PadRight(3 ); 
         dwReturn["MGART26"] = " ".PadRight(3 ); 
         dwReturn["MGWERT26"] = " ".PadRight(0 ); 
         dwReturn["MGME26"] = " ".PadRight(3 ); 
         dwReturn["MGART36"] = " ".PadRight(3 ); 
         dwReturn["MGWERT36"] = " ".PadRight(8 ); 
         dwReturn["MGME36"] = " ".PadRight(3 ); 
         dwReturn["MGECASNR7"] = " ".PadRight(11 ); 
         dwReturn["MGART17"] = " ".PadRight(3 ); 
         dwReturn["MGWERT17"] = " ".PadRight(0 ); 
         dwReturn["MGME17"] = " ".PadRight(3 ); 
         dwReturn["MGART27"] = " ".PadRight(3 ); 
         dwReturn["MGWERT27"] = " ".PadRight(0 ); 
         dwReturn["MGME27"] = " ".PadRight(3 ); 
         dwReturn["MGART37"] = " ".PadRight(3 ); 
         dwReturn["MGWERT37"] = " ".PadRight(8 ); 
         dwReturn["MGME37"] = " ".PadRight(3 ); 
         dwReturn["MGEXPOHINW1"] = " ".PadRight(50 ); 
         dwReturn["MGEXPOHINW2"] = " ".PadRight(50 ); 
         dwReturn["MGPATEM1"] = " ".PadRight(50 ); 
         dwReturn["MGPATEM2"] = " ".PadRight(50 ); 
         dwReturn["MGSYMATEM"] = " ".PadRight(2 ); 
         dwReturn["MGPHAND1"] = " ".PadRight(50 ); 
         dwReturn["MGPHAND2"] = " ".PadRight(50 ); 
         dwReturn["MGSYMHAND"] = " ".PadRight(2 ); 
         dwReturn["MGPAUGE1"] = " ".PadRight(50 ); 
         dwReturn["MGPAUGE2"] = " ".PadRight(50 ); 
         dwReturn["MGSYMAUG"] = " ".PadRight(2 ); 
         dwReturn["MGPKOERPER1"] = " ".PadRight(50 ); 
         dwReturn["MGPKOERPER2"] = " ".PadRight(50 ); 
         dwReturn["MGSYMKOERP"] = " ".PadRight(2 ); 
         dwReturn["MGPHYGIENE1"] = " ".PadRight(50 ); 
         dwReturn["MGPHYGIENE2"] = " ".PadRight(50 ); 
         dwReturn["MGPHYGIENE3"] = " ".PadRight(50 ); 
         dwReturn["MGFORM"] = " ".PadRight(10 ); 
         dwReturn["MGFARBE"] = " ".PadRight(20 ); 
         dwReturn["MGGERUCH"] = " ".PadRight(20 ); 
         dwReturn["MGSCHMVON"] = " ".PadRight(0 ); 
         dwReturn["MGSCHMBIS"] = " ".PadRight(0 ); 
         dwReturn["MGSIEDVON"] = " ".PadRight(0 ); 
         dwReturn["MGSIEDBIS"] = " ".PadRight(0 ); 
         dwReturn["MGFLAMMPKT"] = " ".PadRight(0 ); 
         dwReturn["MGZUENDTEM"] = " ".PadRight(0 ); 
         dwReturn["MGKLASSE"] = " ".PadRight(2 ); 
         dwReturn["MGSZUEND"] = " ".PadRight(50 ); 
         dwReturn["MGBRANDF"] = " ".PadRight(50 ); 
         dwReturn["MGEXPLGEF"] = " ".PadRight(50 ); 
         dwReturn["MGEXPLVONG"] = " ".PadRight(0 ); 
         dwReturn["MGEXPLBISG"] = " ".PadRight(0 ); 
         dwReturn["MGEXPLVONV"] = " ".PadRight(0 ); 
         dwReturn["MGEXPLBISV"] = " ".PadRight(0 ); 
         dwReturn["MGDAMPFDRC"] = " ".PadRight(0 ); 
         dwReturn["MGDAMPFDRH"] = " ".PadRight(0 ); 
         dwReturn["MGDICHTE"] = " ".PadRight(0 ); 
         dwReturn["MGDICHTEGV"] = " ".PadRight(0 ); 
         dwReturn["MGDICHTEGB"] = " ".PadRight(0 ); 
         dwReturn["MGSDICHTE"] = " ".PadRight(0 ); 
         dwReturn["MGSDICHTEV"] = " ".PadRight(0 ); 
         dwReturn["MGSDICHTEB"] = " ".PadRight(0 ); 
         dwReturn["MGLOESLC"] = " ".PadRight(0 ); 
         dwReturn["MGLOESLMG"] = " ".PadRight(0 ); 
         dwReturn["MGLOESVOLL"] = " ".PadRight(1 ); 
         dwReturn["MGLSONST"] = " ".PadRight(50 ); 
         dwReturn["MGPHC"] = " ".PadRight(0 ); 
         dwReturn["MGPHV"] = " ".PadRight(0 ); 
         dwReturn["MGPHB"] = " ".PadRight(0 ); 
         dwReturn["MGPHG"] = " ".PadRight(0 ); 
         dwReturn["MGPOW"] = " ".PadRight(0 ); 
         dwReturn["MGVISKO"] = " ".PadRight(0 ); 
         dwReturn["MGWERT"] = " ".PadRight(0 ); 
         dwReturn["MGVISKOBEZ"] = " ".PadRight(10 ); 
         dwReturn["MGTRPRUEF"] = " ".PadRight(0 ); 
         dwReturn["MGLGEHALT"] = " ".PadRight(0 ); 
         dwReturn["MGREAKT"] = " ".PadRight(50 ); 
         dwReturn["MGVERMBED1"] = " ".PadRight(50 ); 
         dwReturn["MGVERMBED2"] = " ".PadRight(50 ); 
         dwReturn["MGVERMBED3"] = " ".PadRight(50 ); 
         dwReturn["MGVERMST1"] = " ".PadRight(50 ); 
         dwReturn["MGVERMST2"] = " ".PadRight(50 ); 
         dwReturn["MGZERSETZT1"] = " ".PadRight(50 ); 
         dwReturn["MGZERSETZT2"] = " ".PadRight(50 ); 
         dwReturn["MGZERSETZT3"] = " ".PadRight(50 ); 
         dwReturn["MGSONSTIG1"] = " ".PadRight(50 ); 
         dwReturn["MGSONSTIG2"] = " ".PadRight(50 ); 
         dwReturn["MGSONSTIG3"] = " ".PadRight(50 ); 
         dwReturn["MGTOXTEST"] = " ".PadRight(4 ); 
         dwReturn["MGTOXWEG"] = " ".PadRight(8 ); 
         dwReturn["MGTOXTIER"] = " ".PadRight(12 ); 
         dwReturn["MGTOXMG"] = " ".PadRight(0 ); 
         dwReturn["MGINHALRIS"] = " ".PadRight(50 ); 
         dwReturn["MGREIZHAUT"] = " ".PadRight(50 ); 
         dwReturn["MGSCHLHAUT"] = " ".PadRight(50 ); 
         dwReturn["MGREIZAUGE"] = " ".PadRight(50 ); 
         dwReturn["MGSENSI"] = " ".PadRight(50 ); 
         dwReturn["MGCHRONITOX1"] = " ".PadRight(50 ); 
         dwReturn["MGCHRONITOX2"] = " ".PadRight(50 ); 
         dwReturn["MGKREBSERZ"] = " ".PadRight(50 ); 
         dwReturn["MGTOXANGA1"] = " ".PadRight(50 ); 
         dwReturn["MGTOXANGA2"] = " ".PadRight(50 ); 
         dwReturn["MGTOXANGA3"] = " ".PadRight(50 ); 
         dwReturn["MGELIMIN1"] = " ".PadRight(50 ); 
         dwReturn["MGELIMIN2"] = " ".PadRight(50 ); 
         dwReturn["MGABBAU"] = " ".PadRight(50 ); 
         dwReturn["MGBIOAKKU1"] = " ".PadRight(50 ); 
         dwReturn["MGBIOAKKU2"] = " ".PadRight(50 ); 
         dwReturn["MGTOXITAET1"] = " ".PadRight(50 ); 
         dwReturn["MGTOXITAET2"] = " ".PadRight(50 ); 
         dwReturn["MGKLAERANL"] = " ".PadRight(50 ); 
         dwReturn["MGOEKOHINW"] = " ".PadRight(50 ); 
         dwReturn["MGCSB"] = " ".PadRight(0 ); 
         dwReturn["MGBSB5"] = " ".PadRight(0 ); 
         dwReturn["MGTOC"] = " ".PadRight(0 ); 
         dwReturn["MGAOX"] = " ".PadRight(0 ); 
         dwReturn["MGN"] = " ".PadRight(0 ); 
         dwReturn["MGP"] = " ".PadRight(0 ); 
         dwReturn["MGMETBEZ1"] = " ".PadRight(6 ); 
         dwReturn["MGMETPROZ1"] = " ".PadRight(0 ); 
         dwReturn["MGMETBEZ2"] = " ".PadRight(6 ); 
         dwReturn["MGMETPROZ2"] = " ".PadRight(0 ); 
         dwReturn["MGMETBEZ3"] = " ".PadRight(6 ); 
         dwReturn["MGMETPROZ3"] = " ".PadRight(0 ); 
         dwReturn["MGMETBEZ4"] = " ".PadRight(6 ); 
         dwReturn["MGMETPROZ4"] = " ".PadRight(0 ); 
         dwReturn["MGEMPF1"] = " ".PadRight(50 ); 
         dwReturn["MGEMPF2"] = " ".PadRight(50 ); 
         dwReturn["MGEMPF3"] = " ".PadRight(50 ); 
         dwReturn["MGABFSCHL"] = " ".PadRight(7 ); 
         dwReturn["MGVERPACK1"] = " ".PadRight(50 ); 
         dwReturn["MGVERPACK2"] = " ".PadRight(50 ); 
         dwReturn["MGVERPACK3"] = " ".PadRight(50 ); 
         dwReturn["MGREINIG1"] = " ".PadRight(50 ); 
         dwReturn["MGREINIG2"] = " ".PadRight(50 ); 
         dwReturn["MGTRANSVER"] = " ".PadRight(4 ); 
         dwReturn["MGTRANS"] = " ".PadRight(4 ); 
         dwReturn["MGMULTIP"] = " ".PadRight(0 ); 
         dwReturn["MGKZGEF"] = " ".PadRight(2 ); 
         dwReturn["MGKZSTOFF"] = " ".PadRight(4 ); 
         dwReturn["MGGEFAUSL"] = " ".PadRight(25 ); 
         dwReturn["MGGEFKL1"] = " ".PadRight(2 ); 
         dwReturn["MGGEFKL2"] = " ".PadRight(2 ); 
         dwReturn["MGGEFZIFF1"] = " ".PadRight(2 ); 
         dwReturn["MGGEFZIFF2"] = " ".PadRight(1 ); 
         dwReturn["MGNOTMIT11"] = " ".PadRight(2 ); 
         dwReturn["MGNOTMIT21"] = " ".PadRight(2 ); 
         dwReturn["MGNOTMIT12"] = " ".PadRight(2 ); 
         dwReturn["MGNOTMIT22"] = " ".PadRight(2 ); 
         dwReturn["MGNOTMIT13"] = " ".PadRight(2 ); 
         dwReturn["MGNOTMIT23"] = " ".PadRight(2 ); 
         dwReturn["MGNOTMIT14"] = " ".PadRight(2 ); 
         dwReturn["MGNOTMIT24"] = " ".PadRight(2 ); 
         dwReturn["MGGEFZETT"] = " ".PadRight(4 ); 
         dwReturn["MGPACKGR"] = " ".PadRight(3 ); 
         dwReturn["MGSTRAS"] = " ".PadRight(0 ); 
         dwReturn["MGBAHN"] = " ".PadRight(7 ); 
         dwReturn["MGERLAUB"] = " ".PadRight(1 ); 
         dwReturn["MGNOGEF1"] = " ".PadRight(4 ); 
         dwReturn["MGNOGEF2"] = " ".PadRight(20 ); 
         dwReturn["MGBEM"] = " ".PadRight(50 ); 
         dwReturn["MGPOSTVER1"] = " ".PadRight(50 ); 
         dwReturn["MGPOSTVER2"] = " ".PadRight(50 ); 
         dwReturn["MGPOSTVER3"] = " ".PadRight(50 ); 
         dwReturn["MGTRANSHIN"] = " ".PadRight(50 ); 
         dwReturn["MGKZEG1"] = " ".PadRight(2 ); 
         dwReturn["MGKZEG2"] = " ".PadRight(2 ); 
         dwReturn["MGKZEG3"] = " ".PadRight(2 ); 
         dwReturn["MGKZEG4"] = " ".PadRight(2 ); 
         dwReturn["MGKZSCHLD1"] = " ".PadRight(50 ); 
         dwReturn["MGKZSCHLD2"] = " ".PadRight(50 ); 
         dwReturn["MGRSATZ1"] = " ".PadRight(11 ); 
         dwReturn["MGRSATZ2"] = " ".PadRight(11 ); 
         dwReturn["MGRSATZ3"] = " ".PadRight(11 ); 
         dwReturn["MGRSATZ4"] = " ".PadRight(11 ); 
         dwReturn["MGRSATZ5"] = " ".PadRight(11 ); 
         dwReturn["MGRSATZ6"] = " ".PadRight(11 ); 
         dwReturn["MGRSATZ7"] = " ".PadRight(11 ); 
         dwReturn["MGRSATZ8"] = " ".PadRight(11 ); 
         dwReturn["MGSSATZ1"] = " ".PadRight(11 ); 
         dwReturn["MGSSATZ2"] = " ".PadRight(11 ); 
         dwReturn["MGSSATZ3"] = " ".PadRight(11 ); 
         dwReturn["MGSSATZ4"] = " ".PadRight(11 ); 
         dwReturn["MGSSATZ5"] = " ".PadRight(11 ); 
         dwReturn["MGSSATZ6"] = " ".PadRight(11 ); 
         dwReturn["MGSSATZ7"] = " ".PadRight(11 ); 
         dwReturn["MGSSATZ8"] = " ".PadRight(11 ); 
         dwReturn["MGSSATZ9"] = " ".PadRight(11 ); 
         dwReturn["MGSSATZ10"] = " ".PadRight(11 ); 
         dwReturn["MGSSATZ11"] = " ".PadRight(11 ); 
         dwReturn["MGSSATZ12"] = " ".PadRight(11 ); 
         dwReturn["MGSSATZ13"] = " ".PadRight(11 ); 
         dwReturn["MGSSATZ14"] = " ".PadRight(11 ); 
         dwReturn["MGSSATZ15"] = " ".PadRight(11 ); 
         dwReturn["MGSSATZ16"] = " ".PadRight(11 ); 
         dwReturn["MGNATVOR1"] = " ".PadRight(50 ); 
         dwReturn["MGNATVOR2"] = " ".PadRight(50 ); 
         dwReturn["MGNATVOR3"] = " ".PadRight(50 ); 
         dwReturn["MGNATVOR4"] = " ".PadRight(50 ); 
         dwReturn["MGVBF"] = " ".PadRight(50 ); 
         dwReturn["MGKL1"] = " ".PadRight(4 ); 
         dwReturn["MGANTEIL1"] = " ".PadRight(20 ); 
         dwReturn["MGPROZ1"] = " ".PadRight(0 ); 
         dwReturn["MGEMIS1"] = " ".PadRight(0 ); 
         dwReturn["MGSTROM1"] = " ".PadRight(0 ); 
         dwReturn["MGKL2"] = " ".PadRight(4 ); 
         dwReturn["MGANTEIL2"] = " ".PadRight(20 ); 
         dwReturn["MGPROZ2"] = " ".PadRight(0 ); 
         dwReturn["MGEMIS2"] = " ".PadRight(0 ); 
         dwReturn["MGSTROM2"] = " ".PadRight(0 ); 
         dwReturn["MGKL3"] = " ".PadRight(4 ); 
         dwReturn["MGANTEIL3"] = " ".PadRight(20 ); 
         dwReturn["MGPROZ3"] = " ".PadRight(0 ); 
         dwReturn["MGEMIS3"] = " ".PadRight(0 ); 
         dwReturn["MGSTROM3"] = " ".PadRight(0 ); 
         dwReturn["MGKL4"] = " ".PadRight(4 ); 
         dwReturn["MGANTEIL4"] = " ".PadRight(20 ); 
         dwReturn["MGPROZ4"] = " ".PadRight(0 ); 
         dwReturn["MGEMIS4"] = " ".PadRight(0 ); 
         dwReturn["MGSTROM4"] = " ".PadRight(0 ); 
         dwReturn["MGKL5"] = " ".PadRight(4 ); 
         dwReturn["MGANTEIL5"] = " ".PadRight(20 ); 
         dwReturn["MGPROZ5"] = " ".PadRight(0 ); 
         dwReturn["MGEMIS5"] = " ".PadRight(0 ); 
         dwReturn["MGSTROM5"] = " ".PadRight(0 ); 
         dwReturn["MGKL6"] = " ".PadRight(4 ); 
         dwReturn["MGANTEIL6"] = " ".PadRight(20 ); 
         dwReturn["MGPROZ6"] = " ".PadRight(0 ); 
         dwReturn["MGEMIS6"] = " ".PadRight(0 ); 
         dwReturn["MGSTROM6"] = " ".PadRight(0 ); 
         dwReturn["MGKL7"] = " ".PadRight(4 ); 
         dwReturn["MGANTEIL7"] = " ".PadRight(20 ); 
         dwReturn["MGPROZ7"] = " ".PadRight(0 ); 
         dwReturn["MGEMIS7"] = " ".PadRight(0 ); 
         dwReturn["MGSTROM7"] = " ".PadRight(0 ); 
         dwReturn["MGKL8"] = " ".PadRight(4 ); 
         dwReturn["MGANTEIL8"] = " ".PadRight(20 ); 
         dwReturn["MGPROZ8"] = " ".PadRight(0 ); 
         dwReturn["MGEMIS8"] = " ".PadRight(0 ); 
         dwReturn["MGSTROM8"] = " ".PadRight(0 ); 
         dwReturn["MGWGEFAEKL"] = " ".PadRight(1 ); 
         dwReturn["MGSONSTVOR1"] = " ".PadRight(50 ); 
         dwReturn["MGSONSTVOR2"] = " ".PadRight(50 ); 
         dwReturn["MGBESCHR1"] = " ".PadRight(50 ); 
         dwReturn["MGBESCHR2"] = " ".PadRight(50 ); 
         dwReturn["MGAENDZL"] = " ".PadRight(0 ); 
         dwReturn["MGAENDBEN"] = " ".PadRight(8 ); 
         dwReturn["MGAENDDAT"] = " ".PadRight(0 ); 
         dwReturn["MGNEUBEN"] = " ".PadRight(8 ); 
         dwReturn["MGNEUDAT"] = " ".PadRight(0 ); 
         dwReturn["MGFILLER"] = " ".PadRight(81 ); 
                    #endregion
                    break;
                case "JLT":

                    break;
                default:

                    break;
            }
            if (IsConvert)
            {
                foreach (DataColumn cm in dwInput.Table.Columns)
                {
                    if (dwInput[cm.ColumnName].ToString() == "")
                        continue;
                    if (dwReturn.Table.Columns.Contains(cm.ColumnName))
                    {
                        dwReturn[cm.ColumnName] = dwInput[cm.ColumnName];
                    }
                }
            }
            return dwReturn;
        }
        public void MapMGSTAMM(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public void SaveMGSTAMM(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryMGSTAMM(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapMGSTAMM(ref dwLocal, dwData);

            if (!flgExist)
            {

                InsertMGSTAMM(dwLocal, ITXDBVERSION);
            }
            UpdateMGSTAMM(dwLocal);
        }
        public void InsertMGSTAMM(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                    or1.CommandText = "INSERT INTO MGSTAMM(VAKBMANDANT, VAKBKOLL, VAKBART, VAKBKUNDNR, VAKBFARBE, VAKBKDARTNR, VAKBKDARTBEZ, VAKBKDFARBNR, VAKBANDRUCK, VAKBMEGEW, VAKBMENGEH, VAKBGEWVON, VAKBGEWBIS, VAKBGEWCA, VAKBGEWFKT, VAKBGEWGRP, VAKBMEGFKT, VAKBMEGGRP, VAKBAENDZL, VAKBAENDBEN, VAKBAENDDAT, VAKBNEUBEN, VAKBNEUDAT, VAKBFILLER)"
                        + " VALUES (:VAKBMANDANT, :VAKBKOLL, :VAKBART, :VAKBKUNDNR, :VAKBFARBE, '                         ', '                         ', '                             ', ' ', '   ', '   ', 0, 0, ' ', '000000000000', ' ', '000000000000', ' ', 0, '        ', '000000', '        ', '      ', '                                          ')";
                    or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                //VAFMANDANT VAFKOLL VAFART VAFFARBE VAFBEZ VAFFFARBE

            }
            
            Connect2Proxy(or1);
        }
        public DataSet QueryMGSTAMM(DataRow dwData, int option = 1)
        {
            DataSet Return;
            DataSet Result = new DataSet();
            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM MGSTAMM WHERE  ROWNUM<2 ";
                    break;
              
                case 99:
                    or1.CommandText = "SELECT * FROM MGSTAMM  WHERE ROWNUM<50";
                    break;
                default:
                    break;
            }
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
                Result.Tables[0].TableName = "MGSTAMM";
            Return = Result;
            return Return;
        }
        public void DeleteMGSTAMM(DataRow dwData, int option = 1)
        {

            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM MGSTAMM   WHERE  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                     or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        } 
      
        public void UpdateMGSTAMM(DataRow dwData, string ITXDBVERSION = "50.24", int option = 1)
        {
            OracleCommand or1;
            DataSet Result = new DataSet();
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region====Command==== 
                    or1.CommandText = "UPDATE MGSTAMM SET "
                    +"MGMANDANT= :MGMANDANT,"
                    +"MGMAT= :MGMAT,"
                    +"MGVAR= :MGVAR,"
                    +"MGSTAKZ= :MGSTAKZ,"
                    +"MGLIEFNR= :MGLIEFNR,"
                    +"MGADRSL= :MGADRSL,"
                    +"MGNOTASKFT= :MGNOTASKFT,"
                    +"MGNOTTEL= :MGNOTTEL,"
                    +"MGSDBLDAT= :MGSDBLDAT,"
                    +"MGSYNONYM1= :MGSYNONYM1,"
                    +"MGSYNONYM2= :MGSYNONYM2,"
                    +"MGSYNONYM3= :MGSYNONYM3,"
                    +"MGSYNONYM4= :MGSYNONYM4,"
                    +"MGSYNONYM5= :MGSYNONYM5,"
                    +"MGCHEMCHAR1= :MGCHEMCHAR1,"
                    +"MGCHEMCHAR2= :MGCHEMCHAR2,"
                    +"MGCHEMCHAR3= :MGCHEMCHAR3,"
                    +"MGCASNR= :MGCASNR,"
                    +"MGEGNR= :MGEGNR,"
                    +"MGEINECS= :MGEINECS,"
                    +"MGZUBEREIT1= :MGZUBEREIT1,"
                    +"MGZUBEREIT2= :MGZUBEREIT2,"
                    +"MGDCASNR1= :MGDCASNR1,"
                    +"MGPROZVON1= :MGPROZVON1,"
                    +"MGPROZBIS1= :MGPROZBIS1,"
                    +"MGKENNB11= :MGKENNB11,"
                    +"MGKENNB21= :MGKENNB21,"
                    +"MGKENNB31= :MGKENNB31,"
                    +"MGRSTZ1= :MGRSTZ1,"
                    +"MGR11= :MGR11,"
                    +"MGR21= :MGR21,"
                    +"MGR31= :MGR31,"
                    +"MGR41= :MGR41,"
                    +"MGDCASNR2= :MGDCASNR2,"
                    +"MGPROZVON2= :MGPROZVON2,"
                    +"MGPROZBIS2= :MGPROZBIS2,"
                    +"MGKENNB12= :MGKENNB12,"
                    +"MGKENNB22= :MGKENNB22,"
                    +"MGKENNB32= :MGKENNB32,"
                    +"MGRSTZ2= :MGRSTZ2,"
                    +"MGR12= :MGR12,"
                    +"MGR22= :MGR22,"
                    +"MGR32= :MGR32,"
                    +"MGR42= :MGR42,"
                    +"MGDCASNR3= :MGDCASNR3,"
                    +"MGPROZVON3= :MGPROZVON3,"
                    +"MGPROZBIS3= :MGPROZBIS3,"
                    +"MGKENNB13= :MGKENNB13,"
                    +"MGKENNB23= :MGKENNB23,"
                    +"MGKENNB33= :MGKENNB33,"
                    +"MGRSTZ3= :MGRSTZ3,"
                    +"MGR13= :MGR13,"
                    +"MGR23= :MGR23,"
                    +"MGR33= :MGR33,"
                    +"MGR43= :MGR43,"
                    +"MGDCASNR4= :MGDCASNR4,"
                    +"MGPROZVON4= :MGPROZVON4,"
                    +"MGPROZBIS4= :MGPROZBIS4,"
                    +"MGKENNB14= :MGKENNB14,"
                    +"MGKENNB24= :MGKENNB24,"
                    +"MGKENNB34= :MGKENNB34,"
                    +"MGRSTZ4= :MGRSTZ4,"
                    +"MGR14= :MGR14,"
                    +"MGR24= :MGR24,"
                    +"MGR34= :MGR34,"
                    +"MGR44= :MGR44,"
                    +"MGDCASNR5= :MGDCASNR5,"
                    +"MGPROZVON5= :MGPROZVON5,"
                    +"MGPROZBIS5= :MGPROZBIS5,"
                    +"MGKENNB15= :MGKENNB15,"
                    +"MGKENNB25= :MGKENNB25,"
                    +"MGKENNB35= :MGKENNB35,"
                    +"MGRSTZ5= :MGRSTZ5,"
                    +"MGR15= :MGR15,"
                    +"MGR25= :MGR25,"
                    +"MGR35= :MGR35,"
                    +"MGR45= :MGR45,"
                    +"MGDCASNR6= :MGDCASNR6,"
                    +"MGPROZVON6= :MGPROZVON6,"
                    +"MGPROZBIS6= :MGPROZBIS6,"
                    +"MGKENNB16= :MGKENNB16,"
                    +"MGKENNB26= :MGKENNB26,"
                    +"MGKENNB36= :MGKENNB36,"
                    +"MGRSTZ6= :MGRSTZ6,"
                    +"MGR16= :MGR16,"
                    +"MGR26= :MGR26,"
                    +"MGR36= :MGR36,"
                    +"MGR46= :MGR46,"
                    +"MGDCASNR7= :MGDCASNR7,"
                    +"MGPROZVON7= :MGPROZVON7,"
                    +"MGPROZBIS7= :MGPROZBIS7,"
                    +"MGKENNB17= :MGKENNB17,"
                    +"MGKENNB27= :MGKENNB27,"
                    +"MGKENNB37= :MGKENNB37,"
                    +"MGRSTZ7= :MGRSTZ7,"
                    +"MGR17= :MGR17,"
                    +"MGR27= :MGR27,"
                    +"MGR37= :MGR37,"
                    +"MGR47= :MGR47,"
                    +"MGGEFAHR1= :MGGEFAHR1,"
                    +"MGGEFAHR2= :MGGEFAHR2,"
                    +"MGGEFAHR3= :MGGEFAHR3,"
                    +"MGGEFAHR4= :MGGEFAHR4,"
                    +"MGGEFAHR5= :MGGEFAHR5,"
                    +"MGGEFAHR6= :MGGEFAHR6,"
                    +"MGGEFAHR7= :MGGEFAHR7,"
                    +"MGGEFAHR8= :MGGEFAHR8,"
                    +"MGALLGEM1= :MGALLGEM1,"
                    +"MGALLGEM2= :MGALLGEM2,"
                    +"MGALLGEM3= :MGALLGEM3,"
                    +"MGSYMALLG= :MGSYMALLG,"
                    +"MGATMEN1= :MGATMEN1,"
                    +"MGATMEN2= :MGATMEN2,"
                    +"MGATMEN3= :MGATMEN3,"
                    +"MGHAUT1= :MGHAUT1,"
                    +"MGHAUT2= :MGHAUT2,"
                    +"MGHAUT3= :MGHAUT3,"
                    +"MGAUGEN1= :MGAUGEN1,"
                    +"MGAUGEN2= :MGAUGEN2,"
                    +"MGAUGEN3= :MGAUGEN3,"
                    +"MGVSCHLUCK1= :MGVSCHLUCK1,"
                    +"MGVSCHLUCK2= :MGVSCHLUCK2,"
                    +"MGVSCHLUCK3= :MGVSCHLUCK3,"
                    +"MGARZT= :MGARZT,"
                    +"MGGLOESCH1= :MGGLOESCH1,"
                    +"MGGLOESCH2= :MGGLOESCH2,"
                    +"MGULOESCH1= :MGULOESCH1,"
                    +"MGULOESCH2= :MGULOESCH2,"
                    +"MGBESGEF1= :MGBESGEF1,"
                    +"MGBESGEF2= :MGBESGEF2,"
                    +"MGSCHUTZ1= :MGSCHUTZ1,"
                    +"MGSCHUTZ2= :MGSCHUTZ2,"
                    +"MGBRAND1= :MGBRAND1,"
                    +"MGBRAND2= :MGBRAND2,"
                    +"MGBRAND3= :MGBRAND3,"
                    +"MGPSCHUTZ1= :MGPSCHUTZ1,"
                    +"MGPSCHUTZ2= :MGPSCHUTZ2,"
                    +"MGUSCHUTZ1= :MGUSCHUTZ1,"
                    +"MGUSCHUTZ2= :MGUSCHUTZ2,"
                    +"MGENTSORG1= :MGENTSORG1,"
                    +"MGENTSORG2= :MGENTSORG2,"
                    +"MGENTSORG3= :MGENTSORG3,"
                    +"MGFREIHINW1= :MGFREIHINW1,"
                    +"MGFREIHINW2= :MGFREIHINW2,"
                    +"MGFREIHINW3= :MGFREIHINW3,"
                    +"MGUMGANG1= :MGUMGANG1,"
                    +"MGUMGANG2= :MGUMGANG2,"
                    +"MGEXPLSCHZ1= :MGEXPLSCHZ1,"
                    +"MGEXPLSCHZ2= :MGEXPLSCHZ2,"
                    +"MGSYMEXPL= :MGSYMEXPL,"
                    +"MGLAGANF1= :MGLAGANF1,"
                    +"MGLAGANF2= :MGLAGANF2,"
                    +"MGLAGHINW1= :MGLAGHINW1,"
                    +"MGLAGHINW2= :MGLAGHINW2,"
                    +"MGLAGBED= :MGLAGBED,"
                    +"MGLAGKL= :MGLAGKL,"
                    +"MGTEMPVON= :MGTEMPVON,"
                    +"MGTEMPBIS= :MGTEMPBIS,"
                    +"MGGESTANL1= :MGGESTANL1,"
                    +"MGGESTANL2= :MGGESTANL2,"
                    +"MGGESTANL3= :MGGESTANL3,"
                    +"MGECASNR1= :MGECASNR1,"
                    +"MGART11= :MGART11,"
                    +"MGWERT11= :MGWERT11,"
                    +"MGME11= :MGME11,"
                    +"MGART21= :MGART21,"
                    +"MGWERT21= :MGWERT21,"
                    +"MGME21= :MGME21,"
                    +"MGART31= :MGART31,"
                    +"MGWERT31= :MGWERT31,"
                    +"MGME31= :MGME31,"
                    +"MGECASNR2= :MGECASNR2,"
                    +"MGART12= :MGART12,"
                    +"MGWERT12= :MGWERT12,"
                    +"MGME12= :MGME12,"
                    +"MGART22= :MGART22,"
                    +"MGWERT22= :MGWERT22,"
                    +"MGME22= :MGME22,"
                    +"MGART32= :MGART32,"
                    +"MGWERT32= :MGWERT32,"
                    +"MGME32= :MGME32,"
                    +"MGECASNR3= :MGECASNR3,"
                    +"MGART13= :MGART13,"
                    +"MGWERT13= :MGWERT13,"
                    +"MGME13= :MGME13,"
                    +"MGART23= :MGART23,"
                    +"MGWERT23= :MGWERT23,"
                    +"MGME23= :MGME23,"
                    +"MGART33= :MGART33,"
                    +"MGWERT33= :MGWERT33,"
                    +"MGME33= :MGME33,"
                    +"MGECASNR4= :MGECASNR4,"
                    +"MGART14= :MGART14,"
                    +"MGWERT14= :MGWERT14,"
                    +"MGME14= :MGME14,"
                    +"MGART24= :MGART24,"
                    +"MGWERT24= :MGWERT24,"
                    +"MGME24= :MGME24,"
                    +"MGART34= :MGART34,"
                    +"MGWERT34= :MGWERT34,"
                    +"MGME34= :MGME34,"
                    +"MGECASNR5= :MGECASNR5,"
                    +"MGART15= :MGART15,"
                    +"MGWERT15= :MGWERT15,"
                    +"MGME15= :MGME15,"
                    +"MGART25= :MGART25,"
                    +"MGWERT25= :MGWERT25,"
                    +"MGME25= :MGME25,"
                    +"MGART35= :MGART35,"
                    +"MGWERT35= :MGWERT35,"
                    +"MGME35= :MGME35,"
                    +"MGECASNR6= :MGECASNR6,"
                    +"MGART16= :MGART16,"
                    +"MGWERT16= :MGWERT16,"
                    +"MGME16= :MGME16,"
                    +"MGART26= :MGART26,"
                    +"MGWERT26= :MGWERT26,"
                    +"MGME26= :MGME26,"
                    +"MGART36= :MGART36,"
                    +"MGWERT36= :MGWERT36,"
                    +"MGME36= :MGME36,"
                    +"MGECASNR7= :MGECASNR7,"
                    +"MGART17= :MGART17,"
                    +"MGWERT17= :MGWERT17,"
                    +"MGME17= :MGME17,"
                    +"MGART27= :MGART27,"
                    +"MGWERT27= :MGWERT27,"
                    +"MGME27= :MGME27,"
                    +"MGART37= :MGART37,"
                    +"MGWERT37= :MGWERT37,"
                    +"MGME37= :MGME37,"
                    +"MGEXPOHINW1= :MGEXPOHINW1,"
                    +"MGEXPOHINW2= :MGEXPOHINW2,"
                    +"MGPATEM1= :MGPATEM1,"
                    +"MGPATEM2= :MGPATEM2,"
                    +"MGSYMATEM= :MGSYMATEM,"
                    +"MGPHAND1= :MGPHAND1,"
                    +"MGPHAND2= :MGPHAND2,"
                    +"MGSYMHAND= :MGSYMHAND,"
                    +"MGPAUGE1= :MGPAUGE1,"
                    +"MGPAUGE2= :MGPAUGE2,"
                    +"MGSYMAUG= :MGSYMAUG,"
                    +"MGPKOERPER1= :MGPKOERPER1,"
                    +"MGPKOERPER2= :MGPKOERPER2,"
                    +"MGSYMKOERP= :MGSYMKOERP,"
                    +"MGPHYGIENE1= :MGPHYGIENE1,"
                    +"MGPHYGIENE2= :MGPHYGIENE2,"
                    +"MGPHYGIENE3= :MGPHYGIENE3,"
                    +"MGFORM= :MGFORM,"
                    +"MGFARBE= :MGFARBE,"
                    +"MGGERUCH= :MGGERUCH,"
                    +"MGSCHMVON= :MGSCHMVON,"
                    +"MGSCHMBIS= :MGSCHMBIS,"
                    +"MGSIEDVON= :MGSIEDVON,"
                    +"MGSIEDBIS= :MGSIEDBIS,"
                    +"MGFLAMMPKT= :MGFLAMMPKT,"
                    +"MGZUENDTEM= :MGZUENDTEM,"
                    +"MGKLASSE= :MGKLASSE,"
                    +"MGSZUEND= :MGSZUEND,"
                    +"MGBRANDF= :MGBRANDF,"
                    +"MGEXPLGEF= :MGEXPLGEF,"
                    +"MGEXPLVONG= :MGEXPLVONG,"
                    +"MGEXPLBISG= :MGEXPLBISG,"
                    +"MGEXPLVONV= :MGEXPLVONV,"
                    +"MGEXPLBISV= :MGEXPLBISV,"
                    +"MGDAMPFDRC= :MGDAMPFDRC,"
                    +"MGDAMPFDRH= :MGDAMPFDRH,"
                    +"MGDICHTE= :MGDICHTE,"
                    +"MGDICHTEGV= :MGDICHTEGV,"
                    +"MGDICHTEGB= :MGDICHTEGB,"
                    +"MGSDICHTE= :MGSDICHTE,"
                    +"MGSDICHTEV= :MGSDICHTEV,"
                    +"MGSDICHTEB= :MGSDICHTEB,"
                    +"MGLOESLC= :MGLOESLC,"
                    +"MGLOESLMG= :MGLOESLMG,"
                    +"MGLOESVOLL= :MGLOESVOLL,"
                    +"MGLSONST= :MGLSONST,"
                    +"MGPHC= :MGPHC,"
                    +"MGPHV= :MGPHV,"
                    +"MGPHB= :MGPHB,"
                    +"MGPHG= :MGPHG,"
                    +"MGPOW= :MGPOW,"
                    +"MGVISKO= :MGVISKO,"
                    +"MGWERT= :MGWERT,"
                    +"MGVISKOBEZ= :MGVISKOBEZ,"
                    +"MGTRPRUEF= :MGTRPRUEF,"
                    +"MGLGEHALT= :MGLGEHALT,"
                    +"MGREAKT= :MGREAKT,"
                    +"MGVERMBED1= :MGVERMBED1,"
                    +"MGVERMBED2= :MGVERMBED2,"
                    +"MGVERMBED3= :MGVERMBED3,"
                    +"MGVERMST1= :MGVERMST1,"
                    +"MGVERMST2= :MGVERMST2,"
                    +"MGZERSETZT1= :MGZERSETZT1,"
                    +"MGZERSETZT2= :MGZERSETZT2,"
                    +"MGZERSETZT3= :MGZERSETZT3,"
                    +"MGSONSTIG1= :MGSONSTIG1,"
                    +"MGSONSTIG2= :MGSONSTIG2,"
                    +"MGSONSTIG3= :MGSONSTIG3,"
                    +"MGTOXTEST= :MGTOXTEST,"
                    +"MGTOXWEG= :MGTOXWEG,"
                    +"MGTOXTIER= :MGTOXTIER,"
                    +"MGTOXMG= :MGTOXMG,"
                    +"MGINHALRIS= :MGINHALRIS,"
                    +"MGREIZHAUT= :MGREIZHAUT,"
                    +"MGSCHLHAUT= :MGSCHLHAUT,"
                    +"MGREIZAUGE= :MGREIZAUGE,"
                    +"MGSENSI= :MGSENSI,"
                    +"MGCHRONITOX1= :MGCHRONITOX1,"
                    +"MGCHRONITOX2= :MGCHRONITOX2,"
                    +"MGKREBSERZ= :MGKREBSERZ,"
                    +"MGTOXANGA1= :MGTOXANGA1,"
                    +"MGTOXANGA2= :MGTOXANGA2,"
                    +"MGTOXANGA3= :MGTOXANGA3,"
                    +"MGELIMIN1= :MGELIMIN1,"
                    +"MGELIMIN2= :MGELIMIN2,"
                    +"MGABBAU= :MGABBAU,"
                    +"MGBIOAKKU1= :MGBIOAKKU1,"
                    +"MGBIOAKKU2= :MGBIOAKKU2,"
                    +"MGTOXITAET1= :MGTOXITAET1,"
                    +"MGTOXITAET2= :MGTOXITAET2,"
                    +"MGKLAERANL= :MGKLAERANL,"
                    +"MGOEKOHINW= :MGOEKOHINW,"
                    +"MGCSB= :MGCSB,"
                    +"MGBSB5= :MGBSB5,"
                    +"MGTOC= :MGTOC,"
                    +"MGAOX= :MGAOX,"
                    +"MGN= :MGN,"
                    +"MGP= :MGP,"
                    +"MGMETBEZ1= :MGMETBEZ1,"
                    +"MGMETPROZ1= :MGMETPROZ1,"
                    +"MGMETBEZ2= :MGMETBEZ2,"
                    +"MGMETPROZ2= :MGMETPROZ2,"
                    +"MGMETBEZ3= :MGMETBEZ3,"
                    +"MGMETPROZ3= :MGMETPROZ3,"
                    +"MGMETBEZ4= :MGMETBEZ4,"
                    +"MGMETPROZ4= :MGMETPROZ4,"
                    +"MGEMPF1= :MGEMPF1,"
                    +"MGEMPF2= :MGEMPF2,"
                    +"MGEMPF3= :MGEMPF3,"
                    +"MGABFSCHL= :MGABFSCHL,"
                    +"MGVERPACK1= :MGVERPACK1,"
                    +"MGVERPACK2= :MGVERPACK2,"
                    +"MGVERPACK3= :MGVERPACK3,"
                    +"MGREINIG1= :MGREINIG1,"
                    +"MGREINIG2= :MGREINIG2,"
                    +"MGTRANSVER= :MGTRANSVER,"
                    +"MGTRANS= :MGTRANS,"
                    +"MGMULTIP= :MGMULTIP,"
                    +"MGKZGEF= :MGKZGEF,"
                    +"MGKZSTOFF= :MGKZSTOFF,"
                    +"MGGEFAUSL= :MGGEFAUSL,"
                    +"MGGEFKL1= :MGGEFKL1,"
                    +"MGGEFKL2= :MGGEFKL2,"
                    +"MGGEFZIFF1= :MGGEFZIFF1,"
                    +"MGGEFZIFF2= :MGGEFZIFF2,"
                    +"MGNOTMIT11= :MGNOTMIT11,"
                    +"MGNOTMIT21= :MGNOTMIT21,"
                    +"MGNOTMIT12= :MGNOTMIT12,"
                    +"MGNOTMIT22= :MGNOTMIT22,"
                    +"MGNOTMIT13= :MGNOTMIT13,"
                    +"MGNOTMIT23= :MGNOTMIT23,"
                    +"MGNOTMIT14= :MGNOTMIT14,"
                    +"MGNOTMIT24= :MGNOTMIT24,"
                    +"MGGEFZETT= :MGGEFZETT,"
                    +"MGPACKGR= :MGPACKGR,"
                    +"MGSTRAS= :MGSTRAS,"
                    +"MGBAHN= :MGBAHN,"
                    +"MGERLAUB= :MGERLAUB,"
                    +"MGNOGEF1= :MGNOGEF1,"
                    +"MGNOGEF2= :MGNOGEF2,"
                    +"MGBEM= :MGBEM,"
                    +"MGPOSTVER1= :MGPOSTVER1,"
                    +"MGPOSTVER2= :MGPOSTVER2,"
                    +"MGPOSTVER3= :MGPOSTVER3,"
                    +"MGTRANSHIN= :MGTRANSHIN,"
                    +"MGKZEG1= :MGKZEG1,"
                    +"MGKZEG2= :MGKZEG2,"
                    +"MGKZEG3= :MGKZEG3,"
                    +"MGKZEG4= :MGKZEG4,"
                    +"MGKZSCHLD1= :MGKZSCHLD1,"
                    +"MGKZSCHLD2= :MGKZSCHLD2,"
                    +"MGRSATZ1= :MGRSATZ1,"
                    +"MGRSATZ2= :MGRSATZ2,"
                    +"MGRSATZ3= :MGRSATZ3,"
                    +"MGRSATZ4= :MGRSATZ4,"
                    +"MGRSATZ5= :MGRSATZ5,"
                    +"MGRSATZ6= :MGRSATZ6,"
                    +"MGRSATZ7= :MGRSATZ7,"
                    +"MGRSATZ8= :MGRSATZ8,"
                    +"MGSSATZ1= :MGSSATZ1,"
                    +"MGSSATZ2= :MGSSATZ2,"
                    +"MGSSATZ3= :MGSSATZ3,"
                    +"MGSSATZ4= :MGSSATZ4,"
                    +"MGSSATZ5= :MGSSATZ5,"
                    +"MGSSATZ6= :MGSSATZ6,"
                    +"MGSSATZ7= :MGSSATZ7,"
                    +"MGSSATZ8= :MGSSATZ8,"
                    +"MGSSATZ9= :MGSSATZ9,"
                    +"MGSSATZ10= :MGSSATZ10,"
                    +"MGSSATZ11= :MGSSATZ11,"
                    +"MGSSATZ12= :MGSSATZ12,"
                    +"MGSSATZ13= :MGSSATZ13,"
                    +"MGSSATZ14= :MGSSATZ14,"
                    +"MGSSATZ15= :MGSSATZ15,"
                    +"MGSSATZ16= :MGSSATZ16,"
                    +"MGNATVOR1= :MGNATVOR1,"
                    +"MGNATVOR2= :MGNATVOR2,"
                    +"MGNATVOR3= :MGNATVOR3,"
                    +"MGNATVOR4= :MGNATVOR4,"
                    +"MGVBF= :MGVBF,"
                    +"MGKL1= :MGKL1,"
                    +"MGANTEIL1= :MGANTEIL1,"
                    +"MGPROZ1= :MGPROZ1,"
                    +"MGEMIS1= :MGEMIS1,"
                    +"MGSTROM1= :MGSTROM1,"
                    +"MGKL2= :MGKL2,"
                    +"MGANTEIL2= :MGANTEIL2,"
                    +"MGPROZ2= :MGPROZ2,"
                    +"MGEMIS2= :MGEMIS2,"
                    +"MGSTROM2= :MGSTROM2,"
                    +"MGKL3= :MGKL3,"
                    +"MGANTEIL3= :MGANTEIL3,"
                    +"MGPROZ3= :MGPROZ3,"
                    +"MGEMIS3= :MGEMIS3,"
                    +"MGSTROM3= :MGSTROM3,"
                    +"MGKL4= :MGKL4,"
                    +"MGANTEIL4= :MGANTEIL4,"
                    +"MGPROZ4= :MGPROZ4,"
                    +"MGEMIS4= :MGEMIS4,"
                    +"MGSTROM4= :MGSTROM4,"
                    +"MGKL5= :MGKL5,"
                    +"MGANTEIL5= :MGANTEIL5,"
                    +"MGPROZ5= :MGPROZ5,"
                    +"MGEMIS5= :MGEMIS5,"
                    +"MGSTROM5= :MGSTROM5,"
                    +"MGKL6= :MGKL6,"
                    +"MGANTEIL6= :MGANTEIL6,"
                    +"MGPROZ6= :MGPROZ6,"
                    +"MGEMIS6= :MGEMIS6,"
                    +"MGSTROM6= :MGSTROM6,"
                    +"MGKL7= :MGKL7,"
                    +"MGANTEIL7= :MGANTEIL7,"
                    +"MGPROZ7= :MGPROZ7,"
                    +"MGEMIS7= :MGEMIS7,"
                    +"MGSTROM7= :MGSTROM7,"
                    +"MGKL8= :MGKL8,"
                    +"MGANTEIL8= :MGANTEIL8,"
                    +"MGPROZ8= :MGPROZ8,"
                    +"MGEMIS8= :MGEMIS8,"
                    +"MGSTROM8= :MGSTROM8,"
                    +"MGWGEFAEKL= :MGWGEFAEKL,"
                    +"MGSONSTVOR1= :MGSONSTVOR1,"
                    +"MGSONSTVOR2= :MGSONSTVOR2,"
                    +"MGBESCHR1= :MGBESCHR1,"
                    +"MGBESCHR2= :MGBESCHR2,"
                    +"MGAENDZL= :MGAENDZL,"
                    +"MGAENDBEN= :MGAENDBEN,"
                    +"MGAENDDAT= :MGAENDDAT,"
                    +"MGNEUBEN= :MGNEUBEN,"
                    +"MGNEUDAT= :MGNEUDAT,"
                    +"MGFILLER= :MGFILLER,"
                        + " WHERE  "
                        + "  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                    #endregion

                    #region====Parameters====
          or1.Parameters.Add("MGMANDANT", OracleType.NVarChar).Value = dwData["MGMANDANT"].ToString(); 
          or1.Parameters.Add("MGMAT", OracleType.NVarChar).Value = dwData["MGMAT"].ToString(); 
          or1.Parameters.Add("MGVAR", OracleType.NVarChar).Value = dwData["MGVAR"].ToString(); 
          or1.Parameters.Add("MGSTAKZ", OracleType.NVarChar).Value = dwData["MGSTAKZ"].ToString(); 
          or1.Parameters.Add("MGLIEFNR", OracleType.NVarChar).Value = dwData["MGLIEFNR"].ToString(); 
          or1.Parameters.Add("MGADRSL", OracleType.NVarChar).Value = dwData["MGADRSL"].ToString(); 
          or1.Parameters.Add("MGNOTASKFT", OracleType.NVarChar).Value = dwData["MGNOTASKFT"].ToString(); 
          or1.Parameters.Add("MGNOTTEL", OracleType.NVarChar).Value = dwData["MGNOTTEL"].ToString(); 
          or1.Parameters.Add("MGSDBLDAT", OracleType.NVarChar).Value = dwData["MGSDBLDAT"].ToString(); 
          or1.Parameters.Add("MGSYNONYM1", OracleType.NVarChar).Value = dwData["MGSYNONYM1"].ToString(); 
          or1.Parameters.Add("MGSYNONYM2", OracleType.NVarChar).Value = dwData["MGSYNONYM2"].ToString(); 
          or1.Parameters.Add("MGSYNONYM3", OracleType.NVarChar).Value = dwData["MGSYNONYM3"].ToString(); 
          or1.Parameters.Add("MGSYNONYM4", OracleType.NVarChar).Value = dwData["MGSYNONYM4"].ToString(); 
          or1.Parameters.Add("MGSYNONYM5", OracleType.NVarChar).Value = dwData["MGSYNONYM5"].ToString(); 
          or1.Parameters.Add("MGCHEMCHAR1", OracleType.NVarChar).Value = dwData["MGCHEMCHAR1"].ToString(); 
          or1.Parameters.Add("MGCHEMCHAR2", OracleType.NVarChar).Value = dwData["MGCHEMCHAR2"].ToString(); 
          or1.Parameters.Add("MGCHEMCHAR3", OracleType.NVarChar).Value = dwData["MGCHEMCHAR3"].ToString(); 
          or1.Parameters.Add("MGCASNR", OracleType.NVarChar).Value = dwData["MGCASNR"].ToString(); 
          or1.Parameters.Add("MGEGNR", OracleType.NVarChar).Value = dwData["MGEGNR"].ToString(); 
          or1.Parameters.Add("MGEINECS", OracleType.NVarChar).Value = dwData["MGEINECS"].ToString(); 
          or1.Parameters.Add("MGZUBEREIT1", OracleType.NVarChar).Value = dwData["MGZUBEREIT1"].ToString(); 
          or1.Parameters.Add("MGZUBEREIT2", OracleType.NVarChar).Value = dwData["MGZUBEREIT2"].ToString(); 
          or1.Parameters.Add("MGDCASNR1", OracleType.NVarChar).Value = dwData["MGDCASNR1"].ToString(); 
          or1.Parameters.Add("MGPROZVON1", OracleType.NVarChar).Value = dwData["MGPROZVON1"].ToString(); 
          or1.Parameters.Add("MGPROZBIS1", OracleType.NVarChar).Value = dwData["MGPROZBIS1"].ToString(); 
          or1.Parameters.Add("MGKENNB11", OracleType.NVarChar).Value = dwData["MGKENNB11"].ToString(); 
          or1.Parameters.Add("MGKENNB21", OracleType.NVarChar).Value = dwData["MGKENNB21"].ToString(); 
          or1.Parameters.Add("MGKENNB31", OracleType.NVarChar).Value = dwData["MGKENNB31"].ToString(); 
          or1.Parameters.Add("MGRSTZ1", OracleType.NVarChar).Value = dwData["MGRSTZ1"].ToString(); 
          or1.Parameters.Add("MGR11", OracleType.NVarChar).Value = dwData["MGR11"].ToString(); 
          or1.Parameters.Add("MGR21", OracleType.NVarChar).Value = dwData["MGR21"].ToString(); 
          or1.Parameters.Add("MGR31", OracleType.NVarChar).Value = dwData["MGR31"].ToString(); 
          or1.Parameters.Add("MGR41", OracleType.NVarChar).Value = dwData["MGR41"].ToString(); 
          or1.Parameters.Add("MGDCASNR2", OracleType.NVarChar).Value = dwData["MGDCASNR2"].ToString(); 
          or1.Parameters.Add("MGPROZVON2", OracleType.NVarChar).Value = dwData["MGPROZVON2"].ToString(); 
          or1.Parameters.Add("MGPROZBIS2", OracleType.NVarChar).Value = dwData["MGPROZBIS2"].ToString(); 
          or1.Parameters.Add("MGKENNB12", OracleType.NVarChar).Value = dwData["MGKENNB12"].ToString(); 
          or1.Parameters.Add("MGKENNB22", OracleType.NVarChar).Value = dwData["MGKENNB22"].ToString(); 
          or1.Parameters.Add("MGKENNB32", OracleType.NVarChar).Value = dwData["MGKENNB32"].ToString(); 
          or1.Parameters.Add("MGRSTZ2", OracleType.NVarChar).Value = dwData["MGRSTZ2"].ToString(); 
          or1.Parameters.Add("MGR12", OracleType.NVarChar).Value = dwData["MGR12"].ToString(); 
          or1.Parameters.Add("MGR22", OracleType.NVarChar).Value = dwData["MGR22"].ToString(); 
          or1.Parameters.Add("MGR32", OracleType.NVarChar).Value = dwData["MGR32"].ToString(); 
          or1.Parameters.Add("MGR42", OracleType.NVarChar).Value = dwData["MGR42"].ToString(); 
          or1.Parameters.Add("MGDCASNR3", OracleType.NVarChar).Value = dwData["MGDCASNR3"].ToString(); 
          or1.Parameters.Add("MGPROZVON3", OracleType.NVarChar).Value = dwData["MGPROZVON3"].ToString(); 
          or1.Parameters.Add("MGPROZBIS3", OracleType.NVarChar).Value = dwData["MGPROZBIS3"].ToString(); 
          or1.Parameters.Add("MGKENNB13", OracleType.NVarChar).Value = dwData["MGKENNB13"].ToString(); 
          or1.Parameters.Add("MGKENNB23", OracleType.NVarChar).Value = dwData["MGKENNB23"].ToString(); 
          or1.Parameters.Add("MGKENNB33", OracleType.NVarChar).Value = dwData["MGKENNB33"].ToString(); 
          or1.Parameters.Add("MGRSTZ3", OracleType.NVarChar).Value = dwData["MGRSTZ3"].ToString(); 
          or1.Parameters.Add("MGR13", OracleType.NVarChar).Value = dwData["MGR13"].ToString(); 
          or1.Parameters.Add("MGR23", OracleType.NVarChar).Value = dwData["MGR23"].ToString(); 
          or1.Parameters.Add("MGR33", OracleType.NVarChar).Value = dwData["MGR33"].ToString(); 
          or1.Parameters.Add("MGR43", OracleType.NVarChar).Value = dwData["MGR43"].ToString(); 
          or1.Parameters.Add("MGDCASNR4", OracleType.NVarChar).Value = dwData["MGDCASNR4"].ToString(); 
          or1.Parameters.Add("MGPROZVON4", OracleType.NVarChar).Value = dwData["MGPROZVON4"].ToString(); 
          or1.Parameters.Add("MGPROZBIS4", OracleType.NVarChar).Value = dwData["MGPROZBIS4"].ToString(); 
          or1.Parameters.Add("MGKENNB14", OracleType.NVarChar).Value = dwData["MGKENNB14"].ToString(); 
          or1.Parameters.Add("MGKENNB24", OracleType.NVarChar).Value = dwData["MGKENNB24"].ToString(); 
          or1.Parameters.Add("MGKENNB34", OracleType.NVarChar).Value = dwData["MGKENNB34"].ToString(); 
          or1.Parameters.Add("MGRSTZ4", OracleType.NVarChar).Value = dwData["MGRSTZ4"].ToString(); 
          or1.Parameters.Add("MGR14", OracleType.NVarChar).Value = dwData["MGR14"].ToString(); 
          or1.Parameters.Add("MGR24", OracleType.NVarChar).Value = dwData["MGR24"].ToString(); 
          or1.Parameters.Add("MGR34", OracleType.NVarChar).Value = dwData["MGR34"].ToString(); 
          or1.Parameters.Add("MGR44", OracleType.NVarChar).Value = dwData["MGR44"].ToString(); 
          or1.Parameters.Add("MGDCASNR5", OracleType.NVarChar).Value = dwData["MGDCASNR5"].ToString(); 
          or1.Parameters.Add("MGPROZVON5", OracleType.NVarChar).Value = dwData["MGPROZVON5"].ToString(); 
          or1.Parameters.Add("MGPROZBIS5", OracleType.NVarChar).Value = dwData["MGPROZBIS5"].ToString(); 
          or1.Parameters.Add("MGKENNB15", OracleType.NVarChar).Value = dwData["MGKENNB15"].ToString(); 
          or1.Parameters.Add("MGKENNB25", OracleType.NVarChar).Value = dwData["MGKENNB25"].ToString(); 
          or1.Parameters.Add("MGKENNB35", OracleType.NVarChar).Value = dwData["MGKENNB35"].ToString(); 
          or1.Parameters.Add("MGRSTZ5", OracleType.NVarChar).Value = dwData["MGRSTZ5"].ToString(); 
          or1.Parameters.Add("MGR15", OracleType.NVarChar).Value = dwData["MGR15"].ToString(); 
          or1.Parameters.Add("MGR25", OracleType.NVarChar).Value = dwData["MGR25"].ToString(); 
          or1.Parameters.Add("MGR35", OracleType.NVarChar).Value = dwData["MGR35"].ToString(); 
          or1.Parameters.Add("MGR45", OracleType.NVarChar).Value = dwData["MGR45"].ToString(); 
          or1.Parameters.Add("MGDCASNR6", OracleType.NVarChar).Value = dwData["MGDCASNR6"].ToString(); 
          or1.Parameters.Add("MGPROZVON6", OracleType.NVarChar).Value = dwData["MGPROZVON6"].ToString(); 
          or1.Parameters.Add("MGPROZBIS6", OracleType.NVarChar).Value = dwData["MGPROZBIS6"].ToString(); 
          or1.Parameters.Add("MGKENNB16", OracleType.NVarChar).Value = dwData["MGKENNB16"].ToString(); 
          or1.Parameters.Add("MGKENNB26", OracleType.NVarChar).Value = dwData["MGKENNB26"].ToString(); 
          or1.Parameters.Add("MGKENNB36", OracleType.NVarChar).Value = dwData["MGKENNB36"].ToString(); 
          or1.Parameters.Add("MGRSTZ6", OracleType.NVarChar).Value = dwData["MGRSTZ6"].ToString(); 
          or1.Parameters.Add("MGR16", OracleType.NVarChar).Value = dwData["MGR16"].ToString(); 
          or1.Parameters.Add("MGR26", OracleType.NVarChar).Value = dwData["MGR26"].ToString(); 
          or1.Parameters.Add("MGR36", OracleType.NVarChar).Value = dwData["MGR36"].ToString(); 
          or1.Parameters.Add("MGR46", OracleType.NVarChar).Value = dwData["MGR46"].ToString(); 
          or1.Parameters.Add("MGDCASNR7", OracleType.NVarChar).Value = dwData["MGDCASNR7"].ToString(); 
          or1.Parameters.Add("MGPROZVON7", OracleType.NVarChar).Value = dwData["MGPROZVON7"].ToString(); 
          or1.Parameters.Add("MGPROZBIS7", OracleType.NVarChar).Value = dwData["MGPROZBIS7"].ToString(); 
          or1.Parameters.Add("MGKENNB17", OracleType.NVarChar).Value = dwData["MGKENNB17"].ToString(); 
          or1.Parameters.Add("MGKENNB27", OracleType.NVarChar).Value = dwData["MGKENNB27"].ToString(); 
          or1.Parameters.Add("MGKENNB37", OracleType.NVarChar).Value = dwData["MGKENNB37"].ToString(); 
          or1.Parameters.Add("MGRSTZ7", OracleType.NVarChar).Value = dwData["MGRSTZ7"].ToString(); 
          or1.Parameters.Add("MGR17", OracleType.NVarChar).Value = dwData["MGR17"].ToString(); 
          or1.Parameters.Add("MGR27", OracleType.NVarChar).Value = dwData["MGR27"].ToString(); 
          or1.Parameters.Add("MGR37", OracleType.NVarChar).Value = dwData["MGR37"].ToString(); 
          or1.Parameters.Add("MGR47", OracleType.NVarChar).Value = dwData["MGR47"].ToString(); 
          or1.Parameters.Add("MGGEFAHR1", OracleType.NVarChar).Value = dwData["MGGEFAHR1"].ToString(); 
          or1.Parameters.Add("MGGEFAHR2", OracleType.NVarChar).Value = dwData["MGGEFAHR2"].ToString(); 
          or1.Parameters.Add("MGGEFAHR3", OracleType.NVarChar).Value = dwData["MGGEFAHR3"].ToString(); 
          or1.Parameters.Add("MGGEFAHR4", OracleType.NVarChar).Value = dwData["MGGEFAHR4"].ToString(); 
          or1.Parameters.Add("MGGEFAHR5", OracleType.NVarChar).Value = dwData["MGGEFAHR5"].ToString(); 
          or1.Parameters.Add("MGGEFAHR6", OracleType.NVarChar).Value = dwData["MGGEFAHR6"].ToString(); 
          or1.Parameters.Add("MGGEFAHR7", OracleType.NVarChar).Value = dwData["MGGEFAHR7"].ToString(); 
          or1.Parameters.Add("MGGEFAHR8", OracleType.NVarChar).Value = dwData["MGGEFAHR8"].ToString(); 
          or1.Parameters.Add("MGALLGEM1", OracleType.NVarChar).Value = dwData["MGALLGEM1"].ToString(); 
          or1.Parameters.Add("MGALLGEM2", OracleType.NVarChar).Value = dwData["MGALLGEM2"].ToString(); 
          or1.Parameters.Add("MGALLGEM3", OracleType.NVarChar).Value = dwData["MGALLGEM3"].ToString(); 
          or1.Parameters.Add("MGSYMALLG", OracleType.NVarChar).Value = dwData["MGSYMALLG"].ToString(); 
          or1.Parameters.Add("MGATMEN1", OracleType.NVarChar).Value = dwData["MGATMEN1"].ToString(); 
          or1.Parameters.Add("MGATMEN2", OracleType.NVarChar).Value = dwData["MGATMEN2"].ToString(); 
          or1.Parameters.Add("MGATMEN3", OracleType.NVarChar).Value = dwData["MGATMEN3"].ToString(); 
          or1.Parameters.Add("MGHAUT1", OracleType.NVarChar).Value = dwData["MGHAUT1"].ToString(); 
          or1.Parameters.Add("MGHAUT2", OracleType.NVarChar).Value = dwData["MGHAUT2"].ToString(); 
          or1.Parameters.Add("MGHAUT3", OracleType.NVarChar).Value = dwData["MGHAUT3"].ToString(); 
          or1.Parameters.Add("MGAUGEN1", OracleType.NVarChar).Value = dwData["MGAUGEN1"].ToString(); 
          or1.Parameters.Add("MGAUGEN2", OracleType.NVarChar).Value = dwData["MGAUGEN2"].ToString(); 
          or1.Parameters.Add("MGAUGEN3", OracleType.NVarChar).Value = dwData["MGAUGEN3"].ToString(); 
          or1.Parameters.Add("MGVSCHLUCK1", OracleType.NVarChar).Value = dwData["MGVSCHLUCK1"].ToString(); 
          or1.Parameters.Add("MGVSCHLUCK2", OracleType.NVarChar).Value = dwData["MGVSCHLUCK2"].ToString(); 
          or1.Parameters.Add("MGVSCHLUCK3", OracleType.NVarChar).Value = dwData["MGVSCHLUCK3"].ToString(); 
          or1.Parameters.Add("MGARZT", OracleType.NVarChar).Value = dwData["MGARZT"].ToString(); 
          or1.Parameters.Add("MGGLOESCH1", OracleType.NVarChar).Value = dwData["MGGLOESCH1"].ToString(); 
          or1.Parameters.Add("MGGLOESCH2", OracleType.NVarChar).Value = dwData["MGGLOESCH2"].ToString(); 
          or1.Parameters.Add("MGULOESCH1", OracleType.NVarChar).Value = dwData["MGULOESCH1"].ToString(); 
          or1.Parameters.Add("MGULOESCH2", OracleType.NVarChar).Value = dwData["MGULOESCH2"].ToString(); 
          or1.Parameters.Add("MGBESGEF1", OracleType.NVarChar).Value = dwData["MGBESGEF1"].ToString(); 
          or1.Parameters.Add("MGBESGEF2", OracleType.NVarChar).Value = dwData["MGBESGEF2"].ToString(); 
          or1.Parameters.Add("MGSCHUTZ1", OracleType.NVarChar).Value = dwData["MGSCHUTZ1"].ToString(); 
          or1.Parameters.Add("MGSCHUTZ2", OracleType.NVarChar).Value = dwData["MGSCHUTZ2"].ToString(); 
          or1.Parameters.Add("MGBRAND1", OracleType.NVarChar).Value = dwData["MGBRAND1"].ToString(); 
          or1.Parameters.Add("MGBRAND2", OracleType.NVarChar).Value = dwData["MGBRAND2"].ToString(); 
          or1.Parameters.Add("MGBRAND3", OracleType.NVarChar).Value = dwData["MGBRAND3"].ToString(); 
          or1.Parameters.Add("MGPSCHUTZ1", OracleType.NVarChar).Value = dwData["MGPSCHUTZ1"].ToString(); 
          or1.Parameters.Add("MGPSCHUTZ2", OracleType.NVarChar).Value = dwData["MGPSCHUTZ2"].ToString(); 
          or1.Parameters.Add("MGUSCHUTZ1", OracleType.NVarChar).Value = dwData["MGUSCHUTZ1"].ToString(); 
          or1.Parameters.Add("MGUSCHUTZ2", OracleType.NVarChar).Value = dwData["MGUSCHUTZ2"].ToString(); 
          or1.Parameters.Add("MGENTSORG1", OracleType.NVarChar).Value = dwData["MGENTSORG1"].ToString(); 
          or1.Parameters.Add("MGENTSORG2", OracleType.NVarChar).Value = dwData["MGENTSORG2"].ToString(); 
          or1.Parameters.Add("MGENTSORG3", OracleType.NVarChar).Value = dwData["MGENTSORG3"].ToString(); 
          or1.Parameters.Add("MGFREIHINW1", OracleType.NVarChar).Value = dwData["MGFREIHINW1"].ToString(); 
          or1.Parameters.Add("MGFREIHINW2", OracleType.NVarChar).Value = dwData["MGFREIHINW2"].ToString(); 
          or1.Parameters.Add("MGFREIHINW3", OracleType.NVarChar).Value = dwData["MGFREIHINW3"].ToString(); 
          or1.Parameters.Add("MGUMGANG1", OracleType.NVarChar).Value = dwData["MGUMGANG1"].ToString(); 
          or1.Parameters.Add("MGUMGANG2", OracleType.NVarChar).Value = dwData["MGUMGANG2"].ToString(); 
          or1.Parameters.Add("MGEXPLSCHZ1", OracleType.NVarChar).Value = dwData["MGEXPLSCHZ1"].ToString(); 
          or1.Parameters.Add("MGEXPLSCHZ2", OracleType.NVarChar).Value = dwData["MGEXPLSCHZ2"].ToString(); 
          or1.Parameters.Add("MGSYMEXPL", OracleType.NVarChar).Value = dwData["MGSYMEXPL"].ToString(); 
          or1.Parameters.Add("MGLAGANF1", OracleType.NVarChar).Value = dwData["MGLAGANF1"].ToString(); 
          or1.Parameters.Add("MGLAGANF2", OracleType.NVarChar).Value = dwData["MGLAGANF2"].ToString(); 
          or1.Parameters.Add("MGLAGHINW1", OracleType.NVarChar).Value = dwData["MGLAGHINW1"].ToString(); 
          or1.Parameters.Add("MGLAGHINW2", OracleType.NVarChar).Value = dwData["MGLAGHINW2"].ToString(); 
          or1.Parameters.Add("MGLAGBED", OracleType.NVarChar).Value = dwData["MGLAGBED"].ToString(); 
          or1.Parameters.Add("MGLAGKL", OracleType.NVarChar).Value = dwData["MGLAGKL"].ToString(); 
          or1.Parameters.Add("MGTEMPVON", OracleType.NVarChar).Value = dwData["MGTEMPVON"].ToString(); 
          or1.Parameters.Add("MGTEMPBIS", OracleType.NVarChar).Value = dwData["MGTEMPBIS"].ToString(); 
          or1.Parameters.Add("MGGESTANL1", OracleType.NVarChar).Value = dwData["MGGESTANL1"].ToString(); 
          or1.Parameters.Add("MGGESTANL2", OracleType.NVarChar).Value = dwData["MGGESTANL2"].ToString(); 
          or1.Parameters.Add("MGGESTANL3", OracleType.NVarChar).Value = dwData["MGGESTANL3"].ToString(); 
          or1.Parameters.Add("MGECASNR1", OracleType.NVarChar).Value = dwData["MGECASNR1"].ToString(); 
          or1.Parameters.Add("MGART11", OracleType.NVarChar).Value = dwData["MGART11"].ToString(); 
          or1.Parameters.Add("MGWERT11", OracleType.NVarChar).Value = dwData["MGWERT11"].ToString(); 
          or1.Parameters.Add("MGME11", OracleType.NVarChar).Value = dwData["MGME11"].ToString(); 
          or1.Parameters.Add("MGART21", OracleType.NVarChar).Value = dwData["MGART21"].ToString(); 
          or1.Parameters.Add("MGWERT21", OracleType.NVarChar).Value = dwData["MGWERT21"].ToString(); 
          or1.Parameters.Add("MGME21", OracleType.NVarChar).Value = dwData["MGME21"].ToString(); 
          or1.Parameters.Add("MGART31", OracleType.NVarChar).Value = dwData["MGART31"].ToString(); 
          or1.Parameters.Add("MGWERT31", OracleType.NVarChar).Value = dwData["MGWERT31"].ToString(); 
          or1.Parameters.Add("MGME31", OracleType.NVarChar).Value = dwData["MGME31"].ToString(); 
          or1.Parameters.Add("MGECASNR2", OracleType.NVarChar).Value = dwData["MGECASNR2"].ToString(); 
          or1.Parameters.Add("MGART12", OracleType.NVarChar).Value = dwData["MGART12"].ToString(); 
          or1.Parameters.Add("MGWERT12", OracleType.NVarChar).Value = dwData["MGWERT12"].ToString(); 
          or1.Parameters.Add("MGME12", OracleType.NVarChar).Value = dwData["MGME12"].ToString(); 
          or1.Parameters.Add("MGART22", OracleType.NVarChar).Value = dwData["MGART22"].ToString(); 
          or1.Parameters.Add("MGWERT22", OracleType.NVarChar).Value = dwData["MGWERT22"].ToString(); 
          or1.Parameters.Add("MGME22", OracleType.NVarChar).Value = dwData["MGME22"].ToString(); 
          or1.Parameters.Add("MGART32", OracleType.NVarChar).Value = dwData["MGART32"].ToString(); 
          or1.Parameters.Add("MGWERT32", OracleType.NVarChar).Value = dwData["MGWERT32"].ToString(); 
          or1.Parameters.Add("MGME32", OracleType.NVarChar).Value = dwData["MGME32"].ToString(); 
          or1.Parameters.Add("MGECASNR3", OracleType.NVarChar).Value = dwData["MGECASNR3"].ToString(); 
          or1.Parameters.Add("MGART13", OracleType.NVarChar).Value = dwData["MGART13"].ToString(); 
          or1.Parameters.Add("MGWERT13", OracleType.NVarChar).Value = dwData["MGWERT13"].ToString(); 
          or1.Parameters.Add("MGME13", OracleType.NVarChar).Value = dwData["MGME13"].ToString(); 
          or1.Parameters.Add("MGART23", OracleType.NVarChar).Value = dwData["MGART23"].ToString(); 
          or1.Parameters.Add("MGWERT23", OracleType.NVarChar).Value = dwData["MGWERT23"].ToString(); 
          or1.Parameters.Add("MGME23", OracleType.NVarChar).Value = dwData["MGME23"].ToString(); 
          or1.Parameters.Add("MGART33", OracleType.NVarChar).Value = dwData["MGART33"].ToString(); 
          or1.Parameters.Add("MGWERT33", OracleType.NVarChar).Value = dwData["MGWERT33"].ToString(); 
          or1.Parameters.Add("MGME33", OracleType.NVarChar).Value = dwData["MGME33"].ToString(); 
          or1.Parameters.Add("MGECASNR4", OracleType.NVarChar).Value = dwData["MGECASNR4"].ToString(); 
          or1.Parameters.Add("MGART14", OracleType.NVarChar).Value = dwData["MGART14"].ToString(); 
          or1.Parameters.Add("MGWERT14", OracleType.NVarChar).Value = dwData["MGWERT14"].ToString(); 
          or1.Parameters.Add("MGME14", OracleType.NVarChar).Value = dwData["MGME14"].ToString(); 
          or1.Parameters.Add("MGART24", OracleType.NVarChar).Value = dwData["MGART24"].ToString(); 
          or1.Parameters.Add("MGWERT24", OracleType.NVarChar).Value = dwData["MGWERT24"].ToString(); 
          or1.Parameters.Add("MGME24", OracleType.NVarChar).Value = dwData["MGME24"].ToString(); 
          or1.Parameters.Add("MGART34", OracleType.NVarChar).Value = dwData["MGART34"].ToString(); 
          or1.Parameters.Add("MGWERT34", OracleType.NVarChar).Value = dwData["MGWERT34"].ToString(); 
          or1.Parameters.Add("MGME34", OracleType.NVarChar).Value = dwData["MGME34"].ToString(); 
          or1.Parameters.Add("MGECASNR5", OracleType.NVarChar).Value = dwData["MGECASNR5"].ToString(); 
          or1.Parameters.Add("MGART15", OracleType.NVarChar).Value = dwData["MGART15"].ToString(); 
          or1.Parameters.Add("MGWERT15", OracleType.NVarChar).Value = dwData["MGWERT15"].ToString(); 
          or1.Parameters.Add("MGME15", OracleType.NVarChar).Value = dwData["MGME15"].ToString(); 
          or1.Parameters.Add("MGART25", OracleType.NVarChar).Value = dwData["MGART25"].ToString(); 
          or1.Parameters.Add("MGWERT25", OracleType.NVarChar).Value = dwData["MGWERT25"].ToString(); 
          or1.Parameters.Add("MGME25", OracleType.NVarChar).Value = dwData["MGME25"].ToString(); 
          or1.Parameters.Add("MGART35", OracleType.NVarChar).Value = dwData["MGART35"].ToString(); 
          or1.Parameters.Add("MGWERT35", OracleType.NVarChar).Value = dwData["MGWERT35"].ToString(); 
          or1.Parameters.Add("MGME35", OracleType.NVarChar).Value = dwData["MGME35"].ToString(); 
          or1.Parameters.Add("MGECASNR6", OracleType.NVarChar).Value = dwData["MGECASNR6"].ToString(); 
          or1.Parameters.Add("MGART16", OracleType.NVarChar).Value = dwData["MGART16"].ToString(); 
          or1.Parameters.Add("MGWERT16", OracleType.NVarChar).Value = dwData["MGWERT16"].ToString(); 
          or1.Parameters.Add("MGME16", OracleType.NVarChar).Value = dwData["MGME16"].ToString(); 
          or1.Parameters.Add("MGART26", OracleType.NVarChar).Value = dwData["MGART26"].ToString(); 
          or1.Parameters.Add("MGWERT26", OracleType.NVarChar).Value = dwData["MGWERT26"].ToString(); 
          or1.Parameters.Add("MGME26", OracleType.NVarChar).Value = dwData["MGME26"].ToString(); 
          or1.Parameters.Add("MGART36", OracleType.NVarChar).Value = dwData["MGART36"].ToString(); 
          or1.Parameters.Add("MGWERT36", OracleType.NVarChar).Value = dwData["MGWERT36"].ToString(); 
          or1.Parameters.Add("MGME36", OracleType.NVarChar).Value = dwData["MGME36"].ToString(); 
          or1.Parameters.Add("MGECASNR7", OracleType.NVarChar).Value = dwData["MGECASNR7"].ToString(); 
          or1.Parameters.Add("MGART17", OracleType.NVarChar).Value = dwData["MGART17"].ToString(); 
          or1.Parameters.Add("MGWERT17", OracleType.NVarChar).Value = dwData["MGWERT17"].ToString(); 
          or1.Parameters.Add("MGME17", OracleType.NVarChar).Value = dwData["MGME17"].ToString(); 
          or1.Parameters.Add("MGART27", OracleType.NVarChar).Value = dwData["MGART27"].ToString(); 
          or1.Parameters.Add("MGWERT27", OracleType.NVarChar).Value = dwData["MGWERT27"].ToString(); 
          or1.Parameters.Add("MGME27", OracleType.NVarChar).Value = dwData["MGME27"].ToString(); 
          or1.Parameters.Add("MGART37", OracleType.NVarChar).Value = dwData["MGART37"].ToString(); 
          or1.Parameters.Add("MGWERT37", OracleType.NVarChar).Value = dwData["MGWERT37"].ToString(); 
          or1.Parameters.Add("MGME37", OracleType.NVarChar).Value = dwData["MGME37"].ToString(); 
          or1.Parameters.Add("MGEXPOHINW1", OracleType.NVarChar).Value = dwData["MGEXPOHINW1"].ToString(); 
          or1.Parameters.Add("MGEXPOHINW2", OracleType.NVarChar).Value = dwData["MGEXPOHINW2"].ToString(); 
          or1.Parameters.Add("MGPATEM1", OracleType.NVarChar).Value = dwData["MGPATEM1"].ToString(); 
          or1.Parameters.Add("MGPATEM2", OracleType.NVarChar).Value = dwData["MGPATEM2"].ToString(); 
          or1.Parameters.Add("MGSYMATEM", OracleType.NVarChar).Value = dwData["MGSYMATEM"].ToString(); 
          or1.Parameters.Add("MGPHAND1", OracleType.NVarChar).Value = dwData["MGPHAND1"].ToString(); 
          or1.Parameters.Add("MGPHAND2", OracleType.NVarChar).Value = dwData["MGPHAND2"].ToString(); 
          or1.Parameters.Add("MGSYMHAND", OracleType.NVarChar).Value = dwData["MGSYMHAND"].ToString(); 
          or1.Parameters.Add("MGPAUGE1", OracleType.NVarChar).Value = dwData["MGPAUGE1"].ToString(); 
          or1.Parameters.Add("MGPAUGE2", OracleType.NVarChar).Value = dwData["MGPAUGE2"].ToString(); 
          or1.Parameters.Add("MGSYMAUG", OracleType.NVarChar).Value = dwData["MGSYMAUG"].ToString(); 
          or1.Parameters.Add("MGPKOERPER1", OracleType.NVarChar).Value = dwData["MGPKOERPER1"].ToString(); 
          or1.Parameters.Add("MGPKOERPER2", OracleType.NVarChar).Value = dwData["MGPKOERPER2"].ToString(); 
          or1.Parameters.Add("MGSYMKOERP", OracleType.NVarChar).Value = dwData["MGSYMKOERP"].ToString(); 
          or1.Parameters.Add("MGPHYGIENE1", OracleType.NVarChar).Value = dwData["MGPHYGIENE1"].ToString(); 
          or1.Parameters.Add("MGPHYGIENE2", OracleType.NVarChar).Value = dwData["MGPHYGIENE2"].ToString(); 
          or1.Parameters.Add("MGPHYGIENE3", OracleType.NVarChar).Value = dwData["MGPHYGIENE3"].ToString(); 
          or1.Parameters.Add("MGFORM", OracleType.NVarChar).Value = dwData["MGFORM"].ToString(); 
          or1.Parameters.Add("MGFARBE", OracleType.NVarChar).Value = dwData["MGFARBE"].ToString(); 
          or1.Parameters.Add("MGGERUCH", OracleType.NVarChar).Value = dwData["MGGERUCH"].ToString(); 
          or1.Parameters.Add("MGSCHMVON", OracleType.NVarChar).Value = dwData["MGSCHMVON"].ToString(); 
          or1.Parameters.Add("MGSCHMBIS", OracleType.NVarChar).Value = dwData["MGSCHMBIS"].ToString(); 
          or1.Parameters.Add("MGSIEDVON", OracleType.NVarChar).Value = dwData["MGSIEDVON"].ToString(); 
          or1.Parameters.Add("MGSIEDBIS", OracleType.NVarChar).Value = dwData["MGSIEDBIS"].ToString(); 
          or1.Parameters.Add("MGFLAMMPKT", OracleType.NVarChar).Value = dwData["MGFLAMMPKT"].ToString(); 
          or1.Parameters.Add("MGZUENDTEM", OracleType.NVarChar).Value = dwData["MGZUENDTEM"].ToString(); 
          or1.Parameters.Add("MGKLASSE", OracleType.NVarChar).Value = dwData["MGKLASSE"].ToString(); 
          or1.Parameters.Add("MGSZUEND", OracleType.NVarChar).Value = dwData["MGSZUEND"].ToString(); 
          or1.Parameters.Add("MGBRANDF", OracleType.NVarChar).Value = dwData["MGBRANDF"].ToString(); 
          or1.Parameters.Add("MGEXPLGEF", OracleType.NVarChar).Value = dwData["MGEXPLGEF"].ToString(); 
          or1.Parameters.Add("MGEXPLVONG", OracleType.NVarChar).Value = dwData["MGEXPLVONG"].ToString(); 
          or1.Parameters.Add("MGEXPLBISG", OracleType.NVarChar).Value = dwData["MGEXPLBISG"].ToString(); 
          or1.Parameters.Add("MGEXPLVONV", OracleType.NVarChar).Value = dwData["MGEXPLVONV"].ToString(); 
          or1.Parameters.Add("MGEXPLBISV", OracleType.NVarChar).Value = dwData["MGEXPLBISV"].ToString(); 
          or1.Parameters.Add("MGDAMPFDRC", OracleType.NVarChar).Value = dwData["MGDAMPFDRC"].ToString(); 
          or1.Parameters.Add("MGDAMPFDRH", OracleType.NVarChar).Value = dwData["MGDAMPFDRH"].ToString(); 
          or1.Parameters.Add("MGDICHTE", OracleType.NVarChar).Value = dwData["MGDICHTE"].ToString(); 
          or1.Parameters.Add("MGDICHTEGV", OracleType.NVarChar).Value = dwData["MGDICHTEGV"].ToString(); 
          or1.Parameters.Add("MGDICHTEGB", OracleType.NVarChar).Value = dwData["MGDICHTEGB"].ToString(); 
          or1.Parameters.Add("MGSDICHTE", OracleType.NVarChar).Value = dwData["MGSDICHTE"].ToString(); 
          or1.Parameters.Add("MGSDICHTEV", OracleType.NVarChar).Value = dwData["MGSDICHTEV"].ToString(); 
          or1.Parameters.Add("MGSDICHTEB", OracleType.NVarChar).Value = dwData["MGSDICHTEB"].ToString(); 
          or1.Parameters.Add("MGLOESLC", OracleType.NVarChar).Value = dwData["MGLOESLC"].ToString(); 
          or1.Parameters.Add("MGLOESLMG", OracleType.NVarChar).Value = dwData["MGLOESLMG"].ToString(); 
          or1.Parameters.Add("MGLOESVOLL", OracleType.NVarChar).Value = dwData["MGLOESVOLL"].ToString(); 
          or1.Parameters.Add("MGLSONST", OracleType.NVarChar).Value = dwData["MGLSONST"].ToString(); 
          or1.Parameters.Add("MGPHC", OracleType.NVarChar).Value = dwData["MGPHC"].ToString(); 
          or1.Parameters.Add("MGPHV", OracleType.NVarChar).Value = dwData["MGPHV"].ToString(); 
          or1.Parameters.Add("MGPHB", OracleType.NVarChar).Value = dwData["MGPHB"].ToString(); 
          or1.Parameters.Add("MGPHG", OracleType.NVarChar).Value = dwData["MGPHG"].ToString(); 
          or1.Parameters.Add("MGPOW", OracleType.NVarChar).Value = dwData["MGPOW"].ToString(); 
          or1.Parameters.Add("MGVISKO", OracleType.NVarChar).Value = dwData["MGVISKO"].ToString(); 
          or1.Parameters.Add("MGWERT", OracleType.NVarChar).Value = dwData["MGWERT"].ToString(); 
          or1.Parameters.Add("MGVISKOBEZ", OracleType.NVarChar).Value = dwData["MGVISKOBEZ"].ToString(); 
          or1.Parameters.Add("MGTRPRUEF", OracleType.NVarChar).Value = dwData["MGTRPRUEF"].ToString(); 
          or1.Parameters.Add("MGLGEHALT", OracleType.NVarChar).Value = dwData["MGLGEHALT"].ToString(); 
          or1.Parameters.Add("MGREAKT", OracleType.NVarChar).Value = dwData["MGREAKT"].ToString(); 
          or1.Parameters.Add("MGVERMBED1", OracleType.NVarChar).Value = dwData["MGVERMBED1"].ToString(); 
          or1.Parameters.Add("MGVERMBED2", OracleType.NVarChar).Value = dwData["MGVERMBED2"].ToString(); 
          or1.Parameters.Add("MGVERMBED3", OracleType.NVarChar).Value = dwData["MGVERMBED3"].ToString(); 
          or1.Parameters.Add("MGVERMST1", OracleType.NVarChar).Value = dwData["MGVERMST1"].ToString(); 
          or1.Parameters.Add("MGVERMST2", OracleType.NVarChar).Value = dwData["MGVERMST2"].ToString(); 
          or1.Parameters.Add("MGZERSETZT1", OracleType.NVarChar).Value = dwData["MGZERSETZT1"].ToString(); 
          or1.Parameters.Add("MGZERSETZT2", OracleType.NVarChar).Value = dwData["MGZERSETZT2"].ToString(); 
          or1.Parameters.Add("MGZERSETZT3", OracleType.NVarChar).Value = dwData["MGZERSETZT3"].ToString(); 
          or1.Parameters.Add("MGSONSTIG1", OracleType.NVarChar).Value = dwData["MGSONSTIG1"].ToString(); 
          or1.Parameters.Add("MGSONSTIG2", OracleType.NVarChar).Value = dwData["MGSONSTIG2"].ToString(); 
          or1.Parameters.Add("MGSONSTIG3", OracleType.NVarChar).Value = dwData["MGSONSTIG3"].ToString(); 
          or1.Parameters.Add("MGTOXTEST", OracleType.NVarChar).Value = dwData["MGTOXTEST"].ToString(); 
          or1.Parameters.Add("MGTOXWEG", OracleType.NVarChar).Value = dwData["MGTOXWEG"].ToString(); 
          or1.Parameters.Add("MGTOXTIER", OracleType.NVarChar).Value = dwData["MGTOXTIER"].ToString(); 
          or1.Parameters.Add("MGTOXMG", OracleType.NVarChar).Value = dwData["MGTOXMG"].ToString(); 
          or1.Parameters.Add("MGINHALRIS", OracleType.NVarChar).Value = dwData["MGINHALRIS"].ToString(); 
          or1.Parameters.Add("MGREIZHAUT", OracleType.NVarChar).Value = dwData["MGREIZHAUT"].ToString(); 
          or1.Parameters.Add("MGSCHLHAUT", OracleType.NVarChar).Value = dwData["MGSCHLHAUT"].ToString(); 
          or1.Parameters.Add("MGREIZAUGE", OracleType.NVarChar).Value = dwData["MGREIZAUGE"].ToString(); 
          or1.Parameters.Add("MGSENSI", OracleType.NVarChar).Value = dwData["MGSENSI"].ToString(); 
          or1.Parameters.Add("MGCHRONITOX1", OracleType.NVarChar).Value = dwData["MGCHRONITOX1"].ToString(); 
          or1.Parameters.Add("MGCHRONITOX2", OracleType.NVarChar).Value = dwData["MGCHRONITOX2"].ToString(); 
          or1.Parameters.Add("MGKREBSERZ", OracleType.NVarChar).Value = dwData["MGKREBSERZ"].ToString(); 
          or1.Parameters.Add("MGTOXANGA1", OracleType.NVarChar).Value = dwData["MGTOXANGA1"].ToString(); 
          or1.Parameters.Add("MGTOXANGA2", OracleType.NVarChar).Value = dwData["MGTOXANGA2"].ToString(); 
          or1.Parameters.Add("MGTOXANGA3", OracleType.NVarChar).Value = dwData["MGTOXANGA3"].ToString(); 
          or1.Parameters.Add("MGELIMIN1", OracleType.NVarChar).Value = dwData["MGELIMIN1"].ToString(); 
          or1.Parameters.Add("MGELIMIN2", OracleType.NVarChar).Value = dwData["MGELIMIN2"].ToString(); 
          or1.Parameters.Add("MGABBAU", OracleType.NVarChar).Value = dwData["MGABBAU"].ToString(); 
          or1.Parameters.Add("MGBIOAKKU1", OracleType.NVarChar).Value = dwData["MGBIOAKKU1"].ToString(); 
          or1.Parameters.Add("MGBIOAKKU2", OracleType.NVarChar).Value = dwData["MGBIOAKKU2"].ToString(); 
          or1.Parameters.Add("MGTOXITAET1", OracleType.NVarChar).Value = dwData["MGTOXITAET1"].ToString(); 
          or1.Parameters.Add("MGTOXITAET2", OracleType.NVarChar).Value = dwData["MGTOXITAET2"].ToString(); 
          or1.Parameters.Add("MGKLAERANL", OracleType.NVarChar).Value = dwData["MGKLAERANL"].ToString(); 
          or1.Parameters.Add("MGOEKOHINW", OracleType.NVarChar).Value = dwData["MGOEKOHINW"].ToString(); 
          or1.Parameters.Add("MGCSB", OracleType.NVarChar).Value = dwData["MGCSB"].ToString(); 
          or1.Parameters.Add("MGBSB5", OracleType.NVarChar).Value = dwData["MGBSB5"].ToString(); 
          or1.Parameters.Add("MGTOC", OracleType.NVarChar).Value = dwData["MGTOC"].ToString(); 
          or1.Parameters.Add("MGAOX", OracleType.NVarChar).Value = dwData["MGAOX"].ToString(); 
          or1.Parameters.Add("MGN", OracleType.NVarChar).Value = dwData["MGN"].ToString(); 
          or1.Parameters.Add("MGP", OracleType.NVarChar).Value = dwData["MGP"].ToString(); 
          or1.Parameters.Add("MGMETBEZ1", OracleType.NVarChar).Value = dwData["MGMETBEZ1"].ToString(); 
          or1.Parameters.Add("MGMETPROZ1", OracleType.NVarChar).Value = dwData["MGMETPROZ1"].ToString(); 
          or1.Parameters.Add("MGMETBEZ2", OracleType.NVarChar).Value = dwData["MGMETBEZ2"].ToString(); 
          or1.Parameters.Add("MGMETPROZ2", OracleType.NVarChar).Value = dwData["MGMETPROZ2"].ToString(); 
          or1.Parameters.Add("MGMETBEZ3", OracleType.NVarChar).Value = dwData["MGMETBEZ3"].ToString(); 
          or1.Parameters.Add("MGMETPROZ3", OracleType.NVarChar).Value = dwData["MGMETPROZ3"].ToString(); 
          or1.Parameters.Add("MGMETBEZ4", OracleType.NVarChar).Value = dwData["MGMETBEZ4"].ToString(); 
          or1.Parameters.Add("MGMETPROZ4", OracleType.NVarChar).Value = dwData["MGMETPROZ4"].ToString(); 
          or1.Parameters.Add("MGEMPF1", OracleType.NVarChar).Value = dwData["MGEMPF1"].ToString(); 
          or1.Parameters.Add("MGEMPF2", OracleType.NVarChar).Value = dwData["MGEMPF2"].ToString(); 
          or1.Parameters.Add("MGEMPF3", OracleType.NVarChar).Value = dwData["MGEMPF3"].ToString(); 
          or1.Parameters.Add("MGABFSCHL", OracleType.NVarChar).Value = dwData["MGABFSCHL"].ToString(); 
          or1.Parameters.Add("MGVERPACK1", OracleType.NVarChar).Value = dwData["MGVERPACK1"].ToString(); 
          or1.Parameters.Add("MGVERPACK2", OracleType.NVarChar).Value = dwData["MGVERPACK2"].ToString(); 
          or1.Parameters.Add("MGVERPACK3", OracleType.NVarChar).Value = dwData["MGVERPACK3"].ToString(); 
          or1.Parameters.Add("MGREINIG1", OracleType.NVarChar).Value = dwData["MGREINIG1"].ToString(); 
          or1.Parameters.Add("MGREINIG2", OracleType.NVarChar).Value = dwData["MGREINIG2"].ToString(); 
          or1.Parameters.Add("MGTRANSVER", OracleType.NVarChar).Value = dwData["MGTRANSVER"].ToString(); 
          or1.Parameters.Add("MGTRANS", OracleType.NVarChar).Value = dwData["MGTRANS"].ToString(); 
          or1.Parameters.Add("MGMULTIP", OracleType.NVarChar).Value = dwData["MGMULTIP"].ToString(); 
          or1.Parameters.Add("MGKZGEF", OracleType.NVarChar).Value = dwData["MGKZGEF"].ToString(); 
          or1.Parameters.Add("MGKZSTOFF", OracleType.NVarChar).Value = dwData["MGKZSTOFF"].ToString(); 
          or1.Parameters.Add("MGGEFAUSL", OracleType.NVarChar).Value = dwData["MGGEFAUSL"].ToString(); 
          or1.Parameters.Add("MGGEFKL1", OracleType.NVarChar).Value = dwData["MGGEFKL1"].ToString(); 
          or1.Parameters.Add("MGGEFKL2", OracleType.NVarChar).Value = dwData["MGGEFKL2"].ToString(); 
          or1.Parameters.Add("MGGEFZIFF1", OracleType.NVarChar).Value = dwData["MGGEFZIFF1"].ToString(); 
          or1.Parameters.Add("MGGEFZIFF2", OracleType.NVarChar).Value = dwData["MGGEFZIFF2"].ToString(); 
          or1.Parameters.Add("MGNOTMIT11", OracleType.NVarChar).Value = dwData["MGNOTMIT11"].ToString(); 
          or1.Parameters.Add("MGNOTMIT21", OracleType.NVarChar).Value = dwData["MGNOTMIT21"].ToString(); 
          or1.Parameters.Add("MGNOTMIT12", OracleType.NVarChar).Value = dwData["MGNOTMIT12"].ToString(); 
          or1.Parameters.Add("MGNOTMIT22", OracleType.NVarChar).Value = dwData["MGNOTMIT22"].ToString(); 
          or1.Parameters.Add("MGNOTMIT13", OracleType.NVarChar).Value = dwData["MGNOTMIT13"].ToString(); 
          or1.Parameters.Add("MGNOTMIT23", OracleType.NVarChar).Value = dwData["MGNOTMIT23"].ToString(); 
          or1.Parameters.Add("MGNOTMIT14", OracleType.NVarChar).Value = dwData["MGNOTMIT14"].ToString(); 
          or1.Parameters.Add("MGNOTMIT24", OracleType.NVarChar).Value = dwData["MGNOTMIT24"].ToString(); 
          or1.Parameters.Add("MGGEFZETT", OracleType.NVarChar).Value = dwData["MGGEFZETT"].ToString(); 
          or1.Parameters.Add("MGPACKGR", OracleType.NVarChar).Value = dwData["MGPACKGR"].ToString(); 
          or1.Parameters.Add("MGSTRAS", OracleType.NVarChar).Value = dwData["MGSTRAS"].ToString(); 
          or1.Parameters.Add("MGBAHN", OracleType.NVarChar).Value = dwData["MGBAHN"].ToString(); 
          or1.Parameters.Add("MGERLAUB", OracleType.NVarChar).Value = dwData["MGERLAUB"].ToString(); 
          or1.Parameters.Add("MGNOGEF1", OracleType.NVarChar).Value = dwData["MGNOGEF1"].ToString(); 
          or1.Parameters.Add("MGNOGEF2", OracleType.NVarChar).Value = dwData["MGNOGEF2"].ToString(); 
          or1.Parameters.Add("MGBEM", OracleType.NVarChar).Value = dwData["MGBEM"].ToString(); 
          or1.Parameters.Add("MGPOSTVER1", OracleType.NVarChar).Value = dwData["MGPOSTVER1"].ToString(); 
          or1.Parameters.Add("MGPOSTVER2", OracleType.NVarChar).Value = dwData["MGPOSTVER2"].ToString(); 
          or1.Parameters.Add("MGPOSTVER3", OracleType.NVarChar).Value = dwData["MGPOSTVER3"].ToString(); 
          or1.Parameters.Add("MGTRANSHIN", OracleType.NVarChar).Value = dwData["MGTRANSHIN"].ToString(); 
          or1.Parameters.Add("MGKZEG1", OracleType.NVarChar).Value = dwData["MGKZEG1"].ToString(); 
          or1.Parameters.Add("MGKZEG2", OracleType.NVarChar).Value = dwData["MGKZEG2"].ToString(); 
          or1.Parameters.Add("MGKZEG3", OracleType.NVarChar).Value = dwData["MGKZEG3"].ToString(); 
          or1.Parameters.Add("MGKZEG4", OracleType.NVarChar).Value = dwData["MGKZEG4"].ToString(); 
          or1.Parameters.Add("MGKZSCHLD1", OracleType.NVarChar).Value = dwData["MGKZSCHLD1"].ToString(); 
          or1.Parameters.Add("MGKZSCHLD2", OracleType.NVarChar).Value = dwData["MGKZSCHLD2"].ToString(); 
          or1.Parameters.Add("MGRSATZ1", OracleType.NVarChar).Value = dwData["MGRSATZ1"].ToString(); 
          or1.Parameters.Add("MGRSATZ2", OracleType.NVarChar).Value = dwData["MGRSATZ2"].ToString(); 
          or1.Parameters.Add("MGRSATZ3", OracleType.NVarChar).Value = dwData["MGRSATZ3"].ToString(); 
          or1.Parameters.Add("MGRSATZ4", OracleType.NVarChar).Value = dwData["MGRSATZ4"].ToString(); 
          or1.Parameters.Add("MGRSATZ5", OracleType.NVarChar).Value = dwData["MGRSATZ5"].ToString(); 
          or1.Parameters.Add("MGRSATZ6", OracleType.NVarChar).Value = dwData["MGRSATZ6"].ToString(); 
          or1.Parameters.Add("MGRSATZ7", OracleType.NVarChar).Value = dwData["MGRSATZ7"].ToString(); 
          or1.Parameters.Add("MGRSATZ8", OracleType.NVarChar).Value = dwData["MGRSATZ8"].ToString(); 
          or1.Parameters.Add("MGSSATZ1", OracleType.NVarChar).Value = dwData["MGSSATZ1"].ToString(); 
          or1.Parameters.Add("MGSSATZ2", OracleType.NVarChar).Value = dwData["MGSSATZ2"].ToString(); 
          or1.Parameters.Add("MGSSATZ3", OracleType.NVarChar).Value = dwData["MGSSATZ3"].ToString(); 
          or1.Parameters.Add("MGSSATZ4", OracleType.NVarChar).Value = dwData["MGSSATZ4"].ToString(); 
          or1.Parameters.Add("MGSSATZ5", OracleType.NVarChar).Value = dwData["MGSSATZ5"].ToString(); 
          or1.Parameters.Add("MGSSATZ6", OracleType.NVarChar).Value = dwData["MGSSATZ6"].ToString(); 
          or1.Parameters.Add("MGSSATZ7", OracleType.NVarChar).Value = dwData["MGSSATZ7"].ToString(); 
          or1.Parameters.Add("MGSSATZ8", OracleType.NVarChar).Value = dwData["MGSSATZ8"].ToString(); 
          or1.Parameters.Add("MGSSATZ9", OracleType.NVarChar).Value = dwData["MGSSATZ9"].ToString(); 
          or1.Parameters.Add("MGSSATZ10", OracleType.NVarChar).Value = dwData["MGSSATZ10"].ToString(); 
          or1.Parameters.Add("MGSSATZ11", OracleType.NVarChar).Value = dwData["MGSSATZ11"].ToString(); 
          or1.Parameters.Add("MGSSATZ12", OracleType.NVarChar).Value = dwData["MGSSATZ12"].ToString(); 
          or1.Parameters.Add("MGSSATZ13", OracleType.NVarChar).Value = dwData["MGSSATZ13"].ToString(); 
          or1.Parameters.Add("MGSSATZ14", OracleType.NVarChar).Value = dwData["MGSSATZ14"].ToString(); 
          or1.Parameters.Add("MGSSATZ15", OracleType.NVarChar).Value = dwData["MGSSATZ15"].ToString(); 
          or1.Parameters.Add("MGSSATZ16", OracleType.NVarChar).Value = dwData["MGSSATZ16"].ToString(); 
          or1.Parameters.Add("MGNATVOR1", OracleType.NVarChar).Value = dwData["MGNATVOR1"].ToString(); 
          or1.Parameters.Add("MGNATVOR2", OracleType.NVarChar).Value = dwData["MGNATVOR2"].ToString(); 
          or1.Parameters.Add("MGNATVOR3", OracleType.NVarChar).Value = dwData["MGNATVOR3"].ToString(); 
          or1.Parameters.Add("MGNATVOR4", OracleType.NVarChar).Value = dwData["MGNATVOR4"].ToString(); 
          or1.Parameters.Add("MGVBF", OracleType.NVarChar).Value = dwData["MGVBF"].ToString(); 
          or1.Parameters.Add("MGKL1", OracleType.NVarChar).Value = dwData["MGKL1"].ToString(); 
          or1.Parameters.Add("MGANTEIL1", OracleType.NVarChar).Value = dwData["MGANTEIL1"].ToString(); 
          or1.Parameters.Add("MGPROZ1", OracleType.NVarChar).Value = dwData["MGPROZ1"].ToString(); 
          or1.Parameters.Add("MGEMIS1", OracleType.NVarChar).Value = dwData["MGEMIS1"].ToString(); 
          or1.Parameters.Add("MGSTROM1", OracleType.NVarChar).Value = dwData["MGSTROM1"].ToString(); 
          or1.Parameters.Add("MGKL2", OracleType.NVarChar).Value = dwData["MGKL2"].ToString(); 
          or1.Parameters.Add("MGANTEIL2", OracleType.NVarChar).Value = dwData["MGANTEIL2"].ToString(); 
          or1.Parameters.Add("MGPROZ2", OracleType.NVarChar).Value = dwData["MGPROZ2"].ToString(); 
          or1.Parameters.Add("MGEMIS2", OracleType.NVarChar).Value = dwData["MGEMIS2"].ToString(); 
          or1.Parameters.Add("MGSTROM2", OracleType.NVarChar).Value = dwData["MGSTROM2"].ToString(); 
          or1.Parameters.Add("MGKL3", OracleType.NVarChar).Value = dwData["MGKL3"].ToString(); 
          or1.Parameters.Add("MGANTEIL3", OracleType.NVarChar).Value = dwData["MGANTEIL3"].ToString(); 
          or1.Parameters.Add("MGPROZ3", OracleType.NVarChar).Value = dwData["MGPROZ3"].ToString(); 
          or1.Parameters.Add("MGEMIS3", OracleType.NVarChar).Value = dwData["MGEMIS3"].ToString(); 
          or1.Parameters.Add("MGSTROM3", OracleType.NVarChar).Value = dwData["MGSTROM3"].ToString(); 
          or1.Parameters.Add("MGKL4", OracleType.NVarChar).Value = dwData["MGKL4"].ToString(); 
          or1.Parameters.Add("MGANTEIL4", OracleType.NVarChar).Value = dwData["MGANTEIL4"].ToString(); 
          or1.Parameters.Add("MGPROZ4", OracleType.NVarChar).Value = dwData["MGPROZ4"].ToString(); 
          or1.Parameters.Add("MGEMIS4", OracleType.NVarChar).Value = dwData["MGEMIS4"].ToString(); 
          or1.Parameters.Add("MGSTROM4", OracleType.NVarChar).Value = dwData["MGSTROM4"].ToString(); 
          or1.Parameters.Add("MGKL5", OracleType.NVarChar).Value = dwData["MGKL5"].ToString(); 
          or1.Parameters.Add("MGANTEIL5", OracleType.NVarChar).Value = dwData["MGANTEIL5"].ToString(); 
          or1.Parameters.Add("MGPROZ5", OracleType.NVarChar).Value = dwData["MGPROZ5"].ToString(); 
          or1.Parameters.Add("MGEMIS5", OracleType.NVarChar).Value = dwData["MGEMIS5"].ToString(); 
          or1.Parameters.Add("MGSTROM5", OracleType.NVarChar).Value = dwData["MGSTROM5"].ToString(); 
          or1.Parameters.Add("MGKL6", OracleType.NVarChar).Value = dwData["MGKL6"].ToString(); 
          or1.Parameters.Add("MGANTEIL6", OracleType.NVarChar).Value = dwData["MGANTEIL6"].ToString(); 
          or1.Parameters.Add("MGPROZ6", OracleType.NVarChar).Value = dwData["MGPROZ6"].ToString(); 
          or1.Parameters.Add("MGEMIS6", OracleType.NVarChar).Value = dwData["MGEMIS6"].ToString(); 
          or1.Parameters.Add("MGSTROM6", OracleType.NVarChar).Value = dwData["MGSTROM6"].ToString(); 
          or1.Parameters.Add("MGKL7", OracleType.NVarChar).Value = dwData["MGKL7"].ToString(); 
          or1.Parameters.Add("MGANTEIL7", OracleType.NVarChar).Value = dwData["MGANTEIL7"].ToString(); 
          or1.Parameters.Add("MGPROZ7", OracleType.NVarChar).Value = dwData["MGPROZ7"].ToString(); 
          or1.Parameters.Add("MGEMIS7", OracleType.NVarChar).Value = dwData["MGEMIS7"].ToString(); 
          or1.Parameters.Add("MGSTROM7", OracleType.NVarChar).Value = dwData["MGSTROM7"].ToString(); 
          or1.Parameters.Add("MGKL8", OracleType.NVarChar).Value = dwData["MGKL8"].ToString(); 
          or1.Parameters.Add("MGANTEIL8", OracleType.NVarChar).Value = dwData["MGANTEIL8"].ToString(); 
          or1.Parameters.Add("MGPROZ8", OracleType.NVarChar).Value = dwData["MGPROZ8"].ToString(); 
          or1.Parameters.Add("MGEMIS8", OracleType.NVarChar).Value = dwData["MGEMIS8"].ToString(); 
          or1.Parameters.Add("MGSTROM8", OracleType.NVarChar).Value = dwData["MGSTROM8"].ToString(); 
          or1.Parameters.Add("MGWGEFAEKL", OracleType.NVarChar).Value = dwData["MGWGEFAEKL"].ToString(); 
          or1.Parameters.Add("MGSONSTVOR1", OracleType.NVarChar).Value = dwData["MGSONSTVOR1"].ToString(); 
          or1.Parameters.Add("MGSONSTVOR2", OracleType.NVarChar).Value = dwData["MGSONSTVOR2"].ToString(); 
          or1.Parameters.Add("MGBESCHR1", OracleType.NVarChar).Value = dwData["MGBESCHR1"].ToString(); 
          or1.Parameters.Add("MGBESCHR2", OracleType.NVarChar).Value = dwData["MGBESCHR2"].ToString(); 
          or1.Parameters.Add("MGAENDZL", OracleType.NVarChar).Value = dwData["MGAENDZL"].ToString(); 
          or1.Parameters.Add("MGAENDBEN", OracleType.NVarChar).Value = dwData["MGAENDBEN"].ToString(); 
          or1.Parameters.Add("MGAENDDAT", OracleType.NVarChar).Value = dwData["MGAENDDAT"].ToString(); 
          or1.Parameters.Add("MGNEUBEN", OracleType.NVarChar).Value = dwData["MGNEUBEN"].ToString(); 
          or1.Parameters.Add("MGNEUDAT", OracleType.NVarChar).Value = dwData["MGNEUDAT"].ToString(); 
          or1.Parameters.Add("MGFILLER", OracleType.NVarChar).Value = dwData["MGFILLER"].ToString(); 
                    #endregion
                    break; 
                default:
                    break;
            }


            Connect2Proxy(or1);
        }
    }
}
